I am using QODBC Web Edition Read/Write 2005 and when I try running the below listed set of insertstatements I get an "invalid operand for operator:...
Jason, FQSaveToCache is a Boolean and needs to be 1 or True (no single quotes on either of them) FYI, you should specify Qty and Rate OR Amount not both all...
What is the SQL statement you are sending; there is a syntax error in it? Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC...
I have reworked the automatic generated sql commands. And now my updating to QB is working properly. Thanks. ... in it? ... <http://www.qodbc.com/> ... ...
I would like to be able to associate a SalesOrderLine item with a specific ProceLevelList entry. It appears that the QuickBooks SDK does not allow access to...
Hi is there a way where you can limit the number of expense lines in QuickBooks? in my Application, i'm exporting the check_detail report and i have a limit of...
Nonprofit Organization needs to convert from PeachTree to QuickBooks in Long Beach, California Area. I will forward your information to Nonprofit Association...
I am trying to write code to edit line items on existing estimates and invoices. When I try to update the existing record in the EstimateLine table, I receive...
If you sent a copy of the SQL you are trying would make it easier to figure out what is wrong. Matt Froncek QODBC Development Support / FLEXquarters Solutions...
Steve, I responded to you in one of the other yahoo newsgroups... please forward us along; we do more of this than anybody. Chuck Vigeant M.Ed. MCSE, CCNA,...
It is written in MS Access. The error occurs on the line "rsEstimateLine.Update". Thanks for the help. Const adOpenStatic = 3 Const adLockOptimistic = 3 Const...
Chuck, I have your response in a pending file. My contact is unavailable until 7/18. At that time I will send my responses to him which will include your...
I'm using an evaluation copy of QODBC Pro to experiment with extracting invoice information from Quickbooks and displaying it in a Crystal report. I'm using...
Quickbooks prompts you do you want to have your reports updated when data has changed? yes / no. My question is when we write an invoice to QB through QODBC,...
Hello all, I am writing an application that would work with different versions of Quickbooks. The QBXML documentation mentions that there have been changes to...
There could be several reasons: First do you have proper permissions set in QuickBooks (i.e. ssn numbers, etc. - the second check box on that permissions...
The QODBC driver handles those changes internally, and it automatically knows what is available per the connection to the existing QuickBooks file. Our Schema...
Look under the Edit>Preferences>Reports & Graphs: you will see the don't refresh option there. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor ...
Chuck, I have checked permissions - they look OK. The version referenced in the Readme file is as follows: QODBC FLEXquarters.com LLC. QODBC Driver for...
104 does fix that... In addition, you only need the invoiceline table as it contains everything that the invoice table does; and if you were to join them, I...
I am working with Microsoft Access and trying to get my application to insert deposit information into the Deposit and DepositLine table. My previous version...
Are you trying to create a deposit for a customer in lieu of receiving a payment against an invoice? Please clarify. I have two suggestions: First try and...
Chuck, I am not trying to deposit against an invoice, just a plain deposit and make the sales entries at that time. I took your first suggestion and started...
Sorry for the error on the DepositTotal as being insertable. All transaction totals are non-insertable, as the line amount will automatically total up that...
I have a routine that successfully creates invoice in quickbooks from Microsoft Access/SQL Server with 1 or many lines. 2 questions Is is possible to add an...
I am trying to run the stored procedure sp_lastinsertid using powerbuilder 6.5. Below are the statements: string ls_tablename ls_tablename = 'billpaymentcheck'...
HAI This is sriniavas from corporate solutions one of our client looking for Oracle DBA Professionals. About client: Surgical Information Systems. SIS Health...
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.
