Does anyone know how the return the sort-field of a recordset?
I use
- Code: Select all Expand view
- oRs = CREATEOBJECT( "ADODB.Recordset" )
oRS:cursortype :=1
oRs:cursorlocation :=3
oRs:locktype := 3
oRs:open('select * FROM klanten ORDER BY naam',ADO_SQL_Connectionstring)
I have try
- Code: Select all Expand view
- msginfo(oRs:sort)
but it is empty
- Code: Select all Expand view
- msginfo(oRs:Source)
is returing the complete command. I could do a at() and seek of the position of 'ORDER BY', and find it so, but I was wondering if it could be easyer
Thanks