I have a large customer table of about 16,000 records.  I'm using QODBC to check an online database and download new customers to QuickBooks and I use SP_LastInserID to grab the ListID for creating an invoice. (i'm using visual basic)

The insert customer works just fine, but SP_LastInsertID Customer does not return an value.  I've read about optimizing data, but I'm not sure how I should go about it in this case.

I've tried optimizing the customer table when the program starts, but it doesn't seem to work.

Any suggestions? 

I actually do keep the connection open.  I run the SP_LastInsertID statement right after the Insert:

sql = "insert blah blah blah"
set objrs = objconn.execute(sql)

sql = "SP_LastInsertID")
set objrs = objconn.execute(sql)

ListID = objrs(0)

This doesn't work.  If I come back into the program (which optimizes the customer table when it starts, I can find the customer by phone number.)

I've tried optimizing using the sp_optimizeupdatesync Customer right after the insert statement but this doesn't work either.

I can see the customer in QuickBooks, but the VP Demo can't find it and my program can't find it unless I do a full optimize.  With 16,000 + cusotmers and multiple inserts that need to be done at a time, this isn't working to well.

I also tried to skip the sp_LastInsertID and just search by phone number - same scenerio, I can not find the customer in either my program or the VB Demo until after I reoptimize the entire folder.

Any suggestions?  Thanks for your help!  I've written into this forum a couple times and I always appreciate your quick response.

Your code needs a table name here:

sql = "insert blah blah blah"
set objrs = objconn.execute(sql)

sql = "SP_LastInsertID customer")
set objrs = objconn.execute(sql)

My recommended settings for using QODBC are shown here. You need to check: Optimize data after an Insert or Update: causes QODBC to do "Load Updated Data" after an insert or update is executed on a table. Useful for programmers (like you) who what to test that their data has succesfully been written to QuickBooks.