|
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
|
|
| Create new Invoices |
| Author |
Message |
|
|
| Posted : 2006-04-12 07:17:21 |
I want to import a whole bunch of old invoices using QODBC.
There appear to be a lot of foreign key constraints in the Invoiceline table, so I was wondering what is the minimal sequence needed to create new invoices and customers.
Like, do I insert the customer first then then the invoice? Or are there other steps to get the other linked fields?
If you could post a sample set of SQL statements, that would be very helpful indeed. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-04-12 08:33:40 |
|
|
|
|
|
| Posted : 2006-04-14 00:44:39 |
So let me get this straight:
In order to add new invoices that have already been paid, I must
1. add the customer
2. get the the customer LISTID of the last insert.
hmm..
But what do I have to do to match that with payment information?
I just want to make sure I'm dealing with as few tables and SQL statements as humanly possible.
Sorry if I'm being thick, but I'm a tad lost. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-04-14 08:43:27 |
|
|
|
|