General information
Title:
Passing very long SQL-Commands to MySQL-Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only