>I am using FoxPro 5 and trying to use SQLEXEC to execute some large SQL scripts that are stored in plain ASCII text file.
>
>I am using FOPEN and FREAD to retrieve the contents of a SQL script file and store them into a string. Then I use SQLEXEC to execute the contents of the string.
>
>I am worry that the character string has limitation and not able to store the whole contents of the file and therefore can't pass to SQLEXEC to process.
>
>Do anyone has better solution such as running the SQL script directory from the file?
>
>Thanks
Ken,
A script file should easily fit VFP string limit (16 Mb). 255 chars limit only applies to literal strings. However possibly I'd use isql to run scripts.
Cetin