There is a limit of 256 characters per string literal (not string variable) and limit of 8,192 character per VFP command. You can overcome first limit by spliting string literals in small pieces and concatenate them with '+' operator. In the second case you can use SQLEXEC() parameters.
>Hello all, its been a while since I have had to do this, and I can't quite remember the proper steps for making this work. If I want to use &x to execute a SQL statement, but the string is too long to fit in the variable. What are the proper steps to execute the SQL statement? I thought I needed to put it into a memo field or something, but I can't seem to get it to work. Thanks for the help.
--sb--