QODBC Stored Procedure Commands
QODBC STORED PROCEDURES
SP_COLUMNS _tablename _
INSTRUCTION: Returns a recordset of the columns in the specified
table.
EXAMPLE: sp_columns Customer
RETURNS:
QUALIFIERNAME
OWNERNAME
TABLENAME
COLUM...
QODBC Functions
QODBC FUNCTIONS
This is a list of all of the SQL functions supported by the QODBC
Driver and their associated syntax.
QODBC STRING FUNCTIONS
ASCII ( _string_exp _)
INSTRUCTION: Returns the ASCII code value of the leftmost characte...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH
SSIS
PROBLEM DESCRIPTION
We are using QODBC driver for connecting QuickBooks with SSIS. I can
able to connect with QuickBooks through SSIS. But Quick books Ex: LIST
ID) nvarchar data c...
TROUBLESHOOTING - CANNOT CREATE NEW TABLE USING QODBC / CANNOT ADD A
NEW FIELD TO QODBC TABLE
PROBLEM DESCRIPTION:
I'm trying to create a new table with VB Demo.
Can you send me a sample query to do this?
SOLUTIONS:
QODBC is an ODBC driver. Please...
TROUBLESHOOTING - ERROR [42S00] [QODBC] INSERT VALUE MUST BE A SIMPLE
VALUE
PROBLEM DESCRIPTION 1:
We have a customer trying to import a credit memo from our database
into QuickBooks using a vb.net program. They are getting the following
error: ERROR [4...
TROUBLESHOOTING: ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT
AVAILABLE IN THIS VERSION OF QUICKBOOKS.
PROBLEM DESCRIPTION:
I am getting error "Error 3250 - This feature is not enabled or not
available in this version of QuickBooks." while I am tryi...
TROUBLESHOOTING - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST
PROBLEM DESCRIPTION:
I have QuickBooks 2014 version & I am using QODBC latest version. I
have a problem with querying customer table using QODBC.
QODBC driver consistently gets stuck o...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING.
PROBLEM DESCRIPTION:
When I run report query, query works very slow & take about 1-5 mins
per simple report like:
"sp_report ARAgingSummary show Current parameters
DateFrom={d'2014-11-12'}, Dat...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM
CUSTOMER TABLE
PROBLEM DESCRIPTION:
How do I access the alternate email address 1 and 2 and the cc email
fields? I don't see them at the customer table.
SOLUTIONS:
You can get CC Email ...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN LINKED SERVER
PROBLEM DESCRIPTION:
I am trying to run a query using an SQL Server database link to
QuickBooks using QRemote. I can set up the linked server fine in SQL
Server and the connection has been t...
TROUBLESHOOTING - CANNOT USE ALIAS IN MS QUERY
PROBLEM DESCRIPTION:
I am getting the below error message when trying to SELECT data
fields AS Alias, the statement runs fine otherwise.
[sql syntax error] Expected lexical element not found:=
Please se...
TROUBLESHOOTING - HOW TO CREATE BLANK INVOICE IN QUICKBOOKS ONLINE
USING QODBC
PROBLEM DESCRIPTION:
How do I create a note (or a blank line) on the invoice? If I do it
the same way that I do it using QODBC for QuickBooks I get an error :
Error sending...
TROUBLESHOOTING - HOW TO SELECT RECORD WHEN VALUE IS NULL
PROBLEM DESCRIPTION:
I am trying to run a report which returns ItemInventory where
LastReceived is NULL I have tried in vain to accomplish this. My
question is what syntax do you use to select a...
PROBLEM DESCRIPTION:
How to use parameter in OPENQUERY
SOLUTIONS:
OPENQUERY does not accept variables for its arguments. You need to
Pass Basic Values as below example:
SELECT QUERY:
DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25)
SELECT @ID = '19...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING
WITH ODBCCOMMAND & PARAMETERS
PROBLEM DESCRIPTION:
QRemote Does not consider FQSaveToCache with working with OdbcCommand
& Parameters
I have an application that creates Sales Order...
TROUBLESHOOTING - ERROR WHILE INSERTING BILL
PROBLEM DESCRIPTION 1:
I am following the below steps and getting the error.
1.First, we have inserted the records in Bill & BillExpenseLine table
and records got inserted successfully.
2.Second, we are in...
TROUBLESHOOTING - GETTING QODBC NOT SUPPORTED ERROR WHILE INSERTING
INVOICE
PROBLEM DESCRIPTION:
I am trying to insert Invoice, But I am getting below error:
[QODBC] Not supported (#10003)
I am using below SQL statements:
INSERT INTO "InvoiceLine...