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 ?

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:

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

[jamesnkk]

Try it this way and see if it helps:

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]

Error message display "Expected End of Statement"

What part of the Sql statement was highlighted?

[puppydogbuddy]

What part of the Sql statement was highlighted?

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

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

[jamesnkk]

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

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.

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 ;)