>Hi all. Now I’ve got a problem. I use Vfp6.0 (sp3) and Ms Sql(7.0). I try to write update statement. I wrote sql string in variable named SQL that is longer than 256 characters, I made separation on four sql strings (SQL1, SQL2, SQL3, SQL4) everyone is less than 256 characters. Than I concatenated my string in one SQL = SQL1 + SQL2 + SQL3 + SQL4 , but in debugger I saw that result string took only 256 characters all rest characters are cutting. Early I did that. What’s happened? Please, help.

Hi Andrew,
What's the exact error you are getting? Is it string too long? If not, tt could be the concatenation is resulting in an invalid SQL statement. A missed quotation mark here or forgetting a space there could generate an error.

FWIW, I consistently create SQL string longer than 256 characters with no problems using the same environment. Also, the debugger is limited in what it will show on the screen so that isn't necessarily a problem.