There is a flag/field in the table for all lists tables called IsActive. 0 = False, 1 = True. That will handle your problem. We will soon have a tool on the...
I got it work by reinstalling the driver while logged into the account I wanted it to work also we are running QB enterprise 4 ... QuickBooks is ... ...
I am having problems with Qodbc Pro (on a 30-day trial basis) and Excel. I am able to create a Query in MS Query without problems. When I try to import data...
Kelly, So each time QuickBooks asks if this application can access the data, you say "ok always" and it keeps popping up the question each time you use it? ...
I'm receiving an error "[qODBC] Not Licensed To Run as a System Service!" when trying to do a DTS import with SQL 2000. I first thought this was because I had...
Branden, We are working on a specific issue with tools like yours. try turning threading off and that should fix it for now. A new build of the driver ...
I am running the evaluation setup of QODBC pro. My Quickbooks file is on a different computer. I am testing it with link tables into Access 2000. When I open...
Rob, Please see our FAQ for this common MS Access issue: http://www.qodbc.com/QODBCfaq.htm#Q:%20Why%20is%20the%20driver%20so%20slow thanks! brad ... Brad...
I'm accessing Quickbooks data via QODBC and my question is this...Is it possible to use the SQL keywords LIKE and WHERE with Quickbooks stored procedures?...
Glen, You can run queries with the LIKE and WHERE conditions, but there are no stored procedures because this is not a database server. Hope that was the ...
I am getting a 3180 transaction is empty with the following code. I am obviously missing something but I could not find an example of addition a bill...
The FQSaveToCache should be set to TRUE. That will store it memory, then the update of the Bill record will save it to QBs along with the header information. ...
Thanks... Do you have an example of an insert statement that would accomplish a simpler/faster insert. The samples I used from the support area on the web...
See if the helps. Example 1 is the simplest and fastest version. 'BILL 'This creates one bill with three lines. Note the FQSaveToCache field, set to True...
Er...I guess I assumed they were stored procs; I talking about the language of the sp_reports in the Reports; as in... sp_report BalanceSheetDetail show Blank,...
The parameter section requires "=" only on each parameter but you can add a WHERE statement at the end, and in the where section you can use the like ...
....or can I get the table origins of these reports? Matt Froncek <matt@...> wrote:The parameter section requires "=" only on each parameter but you can...
You are close. Parameters are settings for the report and not necessarily fields. Just put the <someField> = <someValue> in the where statement with an and. ...
Sp_reports are actual reports from QuickBooks in Row/Column format. This page has the list of sp_report names and their QuickBooks report names and their...
Submitted this to the QODBC Newsgroup earlier today, so pardons if others have seen it, trying to run the gambit of possible solutions here and was wondering...
Erik, perhaps the field names in QuickBooks are too long for this tool? Do any other tables work? try getting a list of tables or perhaps data from a small one...
See here's the odd thing - Macromedia products communicate via their RDS, and when using the Dreamweaver IDE to talk to the server instance, I can browse...
Well, instead of using the DataDirect SequelLink Driver in ColdFusion, I opted for the Sun JDBC-ODBC Bridge instead - now it looks as though information is...
I meant the tables that the sp_reports get their data from. Matt Froncek <matt@...> wrote:Sp_reports are actual reports from QuickBooks in Row/Column...
Make sure you are logged in administrator and reinstall QODBC. brad ... Brad Waddell ** FLEXquarters.com LLC ** voice-mail/fax: 602-532-7019 Postal: 6965 El...
we offer the reports so that you don't need to look up all of the individual data that makes up the reports, but you are free to do so, although intuit...
Still getting the same error - even went so far as to uninstall Build 17 and use Build 19 - and all installations were made using a Windows2k administrator...
I am trying to retreive checks that are written for given bills (accounts payables). I try to use the billLinkedTxn table, but it took 52 hours just pulling a...
You MUST filter your data request to get quicker responses. jumpins included TxnDate, PaidStatus, etc. for a complete list visit the documentation at...
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.
