Running sql scripts in text files -vfp6 1

[foxbldr]

Hi all,

I have bunch of text files that contain sql statements:

ie. contents of Loan.txt (command continuation added at eol)

select ......,........,;
from .................. ;
where ..... ;
order by .., .. into cursor ....

Can somebody suggest me an efficient way of executing queries without reformatting contents (conforms to VFP6 sql) of txt files.

Foxbldr


Foxbldr

 

[bborissov]

VFP 8 or above

SET ENGINEBEHAVIOUR 70
EXECSCRIPT(FILETOSTR([Loan.txt]))
SET ENGINEBEHAVIOUR 90

VFP 7 or smaller

COPMPILE Loan.txt
DO Loan.fxp
ERASE Loan.fxp

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[foxbldr]

Hi BB,

Thanks for your suggestion and that method eases most of subsequent coding in my project.

Foxbldr