run multiple sql statements for pervasive db

[valo]

Hi all, I need your help, I need to run more that 100 different sql statements at the same time and I cannot find the correct way to do this, I tried in Pervasive Control Center but it just let me run one by one, if I try to run more than one Update I get one error about the driver cannot perfom the operation, if I run one by one there is not any problem but I will spend a lot of time.

How can I run more than one update instruction at the same time ??

Thanks in advance
Valo

 

[mirtheil]

When you say "at the same time", do you mean one after the other? If so, using the PCC/SQLDM, you'll need to separate each statement with either a "#" or a ";". Which one you use is up to you but it needs to be set in the properties of SQLDM (Tools then Properties in the menu).

If you've got that, then you can click on "Tools" then "Query" then "Run All SQL Statements". Or if you're using V8, you can click on the toolbar icon that looks like a document with an arrow pointing down (which does the same as the "Run All Statements"

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician