Why can't I sort? Query

Databases
1

I have an SQL statement that selects on a predefined criteria and I want to sort the results in the query before I return them. But I get an error


`rsDataSet = dbFinances.SelectSQL( "SELECT * FROM tblPurchaseSources ORDER BY nomenclature WHERE productType=?", strName )`

← This throws the following error: Database Exception : near “WHERE”: syntax error


rsDataSet = dbFinances.SelectSQL( "SELECT * FROM tblPurchaseSources WHERE productType=?", strName )

but this works…

2

The ORDER BY Keyword must go AFTER the WHERE

2 Likes
3

Oy! Thank you! Well looky thar! It works now!

4

Mark Ivan’s post as the solution please.

1 Like