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

Infomaster · Post by **Infomaster** » Fri 17 Sep 2010 08:14

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.

AlexP · Post by **AlexP** » Mon 20 Sep 2010 07:48

Hello,

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