Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Run more than 1 query at a time? |
Author |
Message |
|
Posted : 2007-06-12 03:12:27 |
Is there a way to import more than 1 item at a time using multiple SQL queries?
For example, I want to import multiple custom price levels for our inventory, which will be thousands of SQL queries.
I can quickly generate all the SQL code I need to import them in, but I can't figure out how to run more than 1 SQL query at a time. It would take a real long time to manully put each SQL query in an run it. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-12 08:31:37 |
For each custom price level, a separate SQL statement will need to be executed. Often this is doen via a programming language or script using a programming loop.
See: Speeding up PriceLevelPerItem INSERTS? for more information. |
|
|
|
|