Hey,
Thanks for the help you've given in the past regarding QODBC. I want to ensure I'm doing this correctly, because everything is running a bit slow.
Here is the way my VB Program works:
1. My program starts and checks an online database for new orders and downloads order and customer info. 2. I insert a new invoice line into QuickBooks for each product ordered. 3. I check the QB Quickbooks database for the customer's information to see if they are already there. If they are - I update them. if not, I insert them. (so far so good). 4. I then create the Invoice using the customer's listid. At this point the QODBC Driver status window pops up and all the invoices get optimized. (this takes a long, long time)
This all works. However, it literally takes hours to optimize the invoice table! It goes through each invoice line of each invoice. Since I have to connect to different databases (an SQL Server DB and QuickBooks) for each order, I can not leave the QB Database connection open and need to reoptimize for the next order.
If i've understood correctly, I can not simply optimize the inventory when the form loads. Or can I?
Thanks again for your help! |