Getting result Header From SQL statement using clarion

[sk2107c]

Hello

Is there a way to get the data and header from from SQL in clarion.

for example:

SQLFile{PROP:SQL}='SELECT field1 as F1,field2 as My_SecondField FROM table1'

I want to to retrieve the data including the header (F1,My_SecondField ,.... etc)
I could do that with VB but failed with clarion.

any suggestions are highly appreciated.