error TOLEAUTO:SORT( 0 )

[damianodec]

Hi,
I have this code:
cQr := "SELECT t0.articolo as codice, t0.descrarticolo as descrizione, t0.ordinamento as ORDINA FROM articoli t0" +;
"WHERE t0.ordinamento LIKE 'XYZ%' ORDER BY t0.ordinamento"

oDbf:Open( cQr , "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILE.mdb", 1, 3 )
oDbf:sort("ORDINA")

and get this error:
Error description: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: SORT
Args:
[ 1] = C ORDINA

Stack Calls
===========
Called from: => TOLEAUTO:SORT( 0 )


can anyone help me please?

[Rick Lipkin]

damianodec

Over the years I have found troubleshooting sql statements easier ( to see ) in this format ..

Code: Select all  Expand view

cQr := "SELECT t0.articolo as codice, "
cQr += "t0.descrarticolo as descrizione, "
cQr += "t0.ordinamento as ORDINA "
cQr += "FROM articoli t0 "
cQr += "WHERE t0.ordinamento LIKE 'XYZ%' ORDER BY t0.ordinamento"
 

Try your sort like this ..

Code: Select all  Expand view

oDbf:sort("t0.ordinamento")
 

Rick Lipkin