topic-25549

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Return Sort of SQL-recordset
Posted: Wed Jan 30, 2013 02:43 PM

Hi,

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

I use

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 (fw): Select all Collapse

msginfo(oRs:sort)

but it is empty

Code (fw): Select all Collapse

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

FiveTech Support Forums

Continue the discussion