MySQL Query Length Truncated

[catchem35]

I have an SQL query that get truncated when placed in the comman box for:

DATABASE
INSERT/UPDATE/DELETE

My query is 7,848 characters with spaces and AA truncates the query at 6,396 characters.

Any suggestions on working around this limitation?

Thank you

[forumsupport]

Hello,

What you can do is, create a variable that reads value from a text file lets say $GlobalVar$. Write your entire SQL query into that file and just select this variable in 'Insert INSERT/UPDATE/DELETE Statement' field. The format of text file should appear as follows,
GlobalVar = "Update Table name ...."

For more information, please refer to our online task to read variable values from a text file. http://www.tethyssolutions.com/T12.htm

Hope that helps.