>What is the best way to pass very long SQL_Commands to an MY_SQL Server ??
>Until now i do like this:
>
>l_command = 'insert into t_table set data1 = "abc",data2= "yxz"..........'
>l_ok= SQLEXEC(l_connection,l_command')

How about like this?

TEXT TO lcCommand
SELECT *
   FROM tables
   WHERE condition1
     AND condition2
   GROUP BY 1
   ORDER BY 2
ENDTEXT