Page 1 of 1

It is possible to determine ORDER BY fields (index field names) from data set?

Posted: Fri 17 Sep 2010 08:14
by Infomaster
Hello

There is example:
I have TOraStoredProc object, linked to stored function in database, which returns sys_refcursor, sorted by column named "MyColumn".
I want to get this column name in my Delphi's code and show it to user.
How can i make this?
Or how can i simple restore initial sorting state of a data set after i changed IndexFieldNames property (clearing it has no effect - data set sorting kept on its last state).

Thank you.

Posted: Mon 20 Sep 2010 07:48
by AlexP
Hello,

You can create the OUT parameter in your stored function where the column name is returned.