Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Special result cursor problem ???
Message
From
13/02/2007 06:35:05
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01194699
Message ID:
01195015
Views:
19
Hello Sergey
Thank you for your quick answer.
Until now I found no way to put 2 commands in a batch.
Again from sql studio i can do this with // on a empty line
create table ...
//
drop table ...
//
commit

When i try this from foxpro
text to xyz
create table ...
//
drop table ...
//
commit
endtext

sqlexec(connr,xyz)
i get an error from the database: invalid end of sql statement pos nn
nn seams to be end of first line ??

Best regards
Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform