AnsweredAssumed Answered

Variables in ExecuteSQL?

Question asked by ChrisJohnston on Nov 3, 2013
Latest reply on Nov 3, 2013 by ChrisJohnston

Title

Variables in ExecuteSQL?

Post

     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.

      

Outcomes