Return Sort of SQL-recordset

[Marc Vanzegbroeck]

Hi,

Does anyone know how the return the sort-field of a recordset?

I use

Code: Select all | Expand

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

msginfo(oRs:sort)

but it is empty

Code: Select all | Expand

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