On the same subject, I am trying to retrieve detailed general ledger information so that I can construct financial statements, both for the current and prior...
use the SQL sp_reports statement. See http://www.qodbc.com/docs/repdoc.htm cpv ... ledger information so that I can construct financial statements, both for...
Is there a way we can see the actual SQL statement for the stored procedure sp_reports to tell us exactly what tables it's pulling from to get the GL...
Gikas, There is no middle layer, the result of the SP_ commands comes directly from the reports available in QuickBooks from the application menu, therefore it...
I just wanted to let everyone know about some of the stuff that has happened to me in the last little while. I spent the last 2 years working 60-90 hours a...
Find your date from tens of thousands of single millionaires here! You don't have to be a millionaire. Free registration. http://www.MillionaireMatch.com/i/13...
Hello, I have read the informative FAQ (Very good info in the "How can I save new records to the Invoice table, Purchase orders and other tables which have...
You can add a customer, but it will need to be a separate SQL INSERT command. Our driver does not support compound INSERT commands, and I'm not even suer SQL...
I am running the following query against QODBC - SELECT * FROM Customer WHERE TimeCreated < " & dLastSync & " OR TimeModified < " & dLastSync dLastSync is a...
Brad, Here is the date format used for SQL timestamp fields: select * from customer where timecreated = {ts '2003-12-15 08:35:40.000'} Hope this helps! brad ...
Has anyone else run into this error: Data provider or other service returned an E_FAIL status. It only started appearing after I installed .046. After...
I was at work today just thinking about the other online when you left hanging there with my fingers in my pussy. I was so pissed. But, I got over it in no...
Dear Sir or Madam, We are interested in using QODBC for Quickooks 2002 as solution for our ColdFusion / MS SQL backend and our Quickbooks accounting software....
Hi Alin. Mark will get in contact with you on Monday if not before with the special web edition test version. Thanks! Brad Waddell Product Manager, QODBC the...
Hello Sir, Sir , I am PowerBuilder 8.0 Developer I want to want to Integreat QuickBooks with Powerbuilder 8.0 . Please tell me how I can , i tried with OLE...
Hi Tom. Are you getting an error? You would not use OLE I would not think but rather ODBC based data controls. I don't have any specific PB information, but...
I have having some difficulty accessing the Company table. When I run a SQL Select statement I get no records returned. If I connect to it as a linked table...
Brad, Try updating your QuickBooks to the latest download version and get our latest version of QODBC build 46 and let me know if the problem still occurs....
I already had the most up to date downloads of QB and am using QODBC build 46. I am using QB for Canada, if that makes a difference. Brad ... From: Brad...
I know there was a bug in QuickBooks that I think was fixed regarding the company type not being chosen. Make sure a company type is chosen for your company...
Contact support@... and send him a trace log. We cannot recreate the problem here. Does it happen with any other tables? thanks. brad ... Brad Waddell **...
I am using QB 2002 with the Read/Write version of the driver. I am able to link the tables in access but when I try and edit I get the error message below: ...
Can anyone please tell me if the syntax for Quickbook sql is the same as the sql for DataFlex?? If so, could someone write an example to how a CASE statement...
Case is not supported as SQL syntax. Sorry, Matt Froncek QODBC Development Support QODBC Driver for Quickbooks - Unleash your data at <http://www.qodbc.com> ...
Can anyone please let me know how i can download the Build 46. I already have the Read-write version of QODBC. I was waiting for the ability to import Custom...
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.
