Andrew, That error, listed in our FAQ, usually means a simple syntax error. I don't find the field called SalesReceiptItemRefFullName anywhere in the data ...
http://www.qodbc.com/docs/html/qodbc/20/tables/qbview_d_sales_receipt_line.asp?qbviewd_id=69 I used the above QuickBooks view, which does show that data...
... values ... ceiptItemRefFullName"") ... you were ... <http://www.qodbc.com> ... Your suggestion moved me towards progress, although by itself it didn't...
Oops! I reread your post and see that you already answered the last part of my question re: single vs. double quotes *chagrin*... ... values ... you were ... ...
Yes, Double quotes and single quotes mean different things to QODBC. Double quotes signify table and field names, single quotes signify constant string values....
Hi I need to select/insert/update and delete data from QuickBooks via a back-office web system written in ColdFusion and figured QODBC may be the answer but I...
Is QBs running on the system console (not in a terminal services window) with your company file open? Are you running the WEB Edition of QODBC? With VBDemo you...
Hi Is there a way I can do a multiple insert query like this one INSERT INTO TestTable SELECT ListId FROM Account or like this SELECT ListId INTO TestTable...
Louis, Yes, that should work, let us know if you have any trouble. brad ... Brad Waddell ** FLEXquarters.com LLC ** voice-mail/fax: 602-532-7019 Postal: 6965...
Hi, I am new to the forum and to QuickBooks/QODBC. Is it possible to set the closing date using QODBC. Also is it possible to "clear" a check using QODBC? ...
Matt, Please see our online documentation. We have a map between the screens in QuickBooks and the elements available for you to access via our driver which...
Hi I'm inserting an invoice and I want to get that last invoice reference number Is there a replacement for the common @@Identity tag ? to return the last...
Fox, The correct format is: WHERE TimeCreated={ts'2003-12-15 11:26:56.000'} Make sure all hours, minutes etc are two digits and add the millisecs also. We do...
INVENTORYADJUSTMENT This creates one inventoryadjustment with three lines. Note the FQSaveToCache field, set to True except on the last one. Note: You must be...
Thank you. I'm trying to use your example (slightly modified) below but I keep getting an "Unexpected extra token" fail error. Any suggestions? INSERT INTO...
I suggest you test removing items from the list until it works. The SQL engine can do the testing for you. thanks! brad ... Brad Waddell ** FLEXquarters.com...
Hi Am I doing something wrong or QODBC doesn't not support embeded queries like this one "SELECT c.ListId,c.FullName,c.ParentRefListId,(SELECT sum(cm.SubTotal)...
Does anyone have a tool to run against a QB database that will munge all name and address info. or even better - selective name and address info. Sometimes...
Our driver can live link QuickBooks data to Access, so any MS Access or VB tool which can talk to an ODBC driver and modify the data within could manage this...
Louis, I'm pretty sure we support only a single level embedded query, I suggest you use a temporary result table to obtain the same result. thanks. brad ... ...
I'm trying to use the Profit And Loss By Job sp_report query in Crystal Reports 8.5 and I get a "Column not found: Amount_Title" error. I get that message with...
Jerry, Can you tell us which version of QODBC and QuickBooks you are using so we can look up the specs for those reports? The documentation was recently ...
What would the be the simplest way of determining the next Invoice number in Quickbooks? I've thought of "SELECT max(refnum) from invoice" or something like...
The next invoice number is not available via the QuickBooks SDK, so our driver cannot access it. For what reason do you need it? If you want QuickBooks to...
First I would upgrade to the current build 50 because there is no field titled like that in the report you mention. Try a * instead of the specific field names...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
