RSS Feed
Knowledgebase : Syntax
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: DECLARE @TSQL varchar(8000), @ID varchar(25) SELECT @ID = '19650' SELECT @TSQ...
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...