hi ,everybody:
I have find a way to sort data by column in program script, but I don't know how to get a column's name :( !
I think choice a column in form can trigger a event , and get the column's name ,but i don't know how to relize it, who can help me ?
thanks!:)

Hi,

You can sort data in program script in SQL statement ORDER BY statement.

The column name is the table column name here.

If you want to sort data by a form field, which is NOT available in table then you can get the form filed name as you would have declared it right in declaration section.

Can you give more info so that we can help??

Regards

thanks,baanprog.
for example:
if I click the column's name on the top, can I get it's name and save it in a variable(string)?