SQL statement Order By

jamesnkk

HI,
I want to set the order by desc in the sql statement, but my statement cause
BOF or EOF, what wrong with the statement ?

Expand|Select|Wrap|Line Numbers

 rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & " ORDER BY sn, debugno desc" & "'", conn
 

puppydogbuddy

Try it this way and see if it helps:

Expand|Select|Wrap|Line Numbers

 
rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" ORDER BY debugno desc" , conn 
 

jamesnkk

Quote:

Originally Posted by puppydogbuddy

Try it this way and see if it helps:

Expand|Select|Wrap|Line Numbers

 
rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" ORDER BY debugno desc" , conn 
 

Error message display "Expected End of Statement"

puppydogbuddy

Quote:

Originally Posted by jamesnkk

Error message display "Expected End of Statement"

What part of the Sql statement was highlighted?

puppydogbuddy

Quote:

Originally Posted by puppydogbuddy

What part of the Sql statement was highlighted?

My mistake....I misread the sql...try it this way:

Expand|Select|Wrap|Line Numbers

 
rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" ORDER BY sn, debugno, desc" , conn
 

jamesnkk

Quote:

Originally Posted by puppydogbuddy

My mistake....I misread the sql...try it this way:

Expand|Select|Wrap|Line Numbers

 
rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" ORDER BY sn, debugno, desc" , conn
 

I think you miss out & and the " before ORDER, I manage to get it right,
thank for the inspiration.

Expand|Select|Wrap|Line Numbers

 rsProcess.Open "select * from Process where SN = '" & Bd_details.Controls(Bsn).Text & "'" & "ORDER BY SN,Debugno desc", conn
 

puppydogbuddy

Yes, you are correct. Sometimes, it is hard to see unless you have the database to in front of you to work with. Glad you got it resolved.

NeoPa

Basically, it was a matter of moving the closing quote (') for the
WHERE SN='blahBla ORDER BY ... '
...so that it comes before the ORDER BY instead of somtime afterwards. The later problems were due to missing and extra double-quotes (") - which can get confusing - especially if you're rushing.

[ CODE ] tags always help to minimise these of course ;)

SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

re: SQL statement Order By

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about