Is it possible via ExecuteSQL to use a variable like this?
This is possible, but not using the syntax you're showing.
Let ( [
~sort = Information::executeSQLSortOrder ;
"SELECT \"name\" FROM \"TopicList\"
WHERE \"id_Information\" = ?
ORDER BY \"name\" "
Also, I see you're quoting literal text for your field names. You should not be doing that in production FileMaker code. FileMaker fields get renamed often, and ExecuteSQL queries built like this don't know when fields get renamed, so it's a best practice to wrap references to FileMaker fields in custom functions so the SQL doesn't break. Exactly what's the best way to do this is not exactly a settled question.