VFP Operator/operand error in .exe only, regular app ok ??? 1

[louie728]

Hello all..I am getting a strange error that I hope someone can help me with. I am building a .qpr file with a sql statement and then running it via macro substitution (DO (varqprfile) or DO &varqprfile ). This works great when I do not compile to a .exe, but when I do compile to .exe it gives me an operator/operand error.....Please help
TIA....

 

[darrellblackhawk]

Need more info.

 

[louie728]

Well basically my program runs a .qpr that it creates on the fly via a do statement (a sql statement is built by user criteria and then copied to a file with the extention .qpr). When not compiled into an .exe it will run the query file which is diffrent every time and creates a .qpr and .qpx (all works great). When the program is compiled into a .exe it will create the .qpr , but does not want to create the .qpx and it bombs with the mentioned error. It will not actually parse the .qpr and create the .qpx...If I have a .qpx there (in the dir where the .qpr is created) it will run it, but this is no good because it is diffrent all the time.

Thanks for your response.....

 

[Mike Gagnon]

LOUIE728

(a sql statement is built by user criteria and then copied to a file with the extention .qpr)

Can you explain why you are doing that? Why not just run the code as written? Store it in a string and run the string.


You may try to compile at runtime the .qpr file (which should generate a .qpx file), if you are using VFP7.0 (I believe COMPILE came out in VFP7.0)

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[louie728]

Mike,

I thank you much. The compile command works like a charm. The reason I did not use the code as written is that the SQl statement was way too long....

Anyway Thank you