Hello everybody!

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')

If the length of l_commands grows to more then 254 characters,
i split the task in two parts

first insert with keyfields and half of fields, then updating the inserted record with the rest of the fields ??????????

I believe that there must be a better way to handle this!
What about very long and complex select commands, that can't be split??
Any idea welcomed

Best regards
Albert