Variable in ExecuteSQL?

[pctechtv]

Is it possible via ExecuteSQL to use a variable like this?

Let (

@sort = INFORMATION::exsqlsort

ExecuteSQL ( " SELECT "name" FROM "TOPICLIST"

WHERE "_fk_infoparent_id" = ?
ORDER BY "name" @sort" ;

"";

"";

INFORMATION::_kp_information_id

)

)

Then I would go to a field named INFORMATION::exsqlsort setup as radio button with the choices ASC and DESC.

[comment]

I believe it needs to be =

...
ORDER BY "name" " & @sort ;
...

Or simply =

...
ORDER BY name " & INFORMATION::exsqlsort ;
...

since translating the field to a variable doesn't really accomplish anything here and it's not necessary to quote the fieldname "name".