4 Replies Latest reply on Nov 3, 2013 5:05 PM by ChrisJohnston

    Variables in ExecuteSQL?

    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.