Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
 Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Help NeededSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 Help Needed 
 Author   Message 
  Pete 
  
 Group: Members 
 Posts: 17 
 Joined: 2007-01-06 
 Profile
 Posted : 2007-11-15 05:03:48

Running QODBC version 8.00.00.239 on windows 2003 server accessing SQL2005. I have created a linked server and am trying to so a simple select into a SQL table ... easy .. so i thought   but i keep getting the following error

Msg 213, Level 16, State 1, Line 5

Insert Error: Column name or number of supplied values does not match table definition.

when running this query -

select * into #tempInvoiceLine from OpenQuery( QODBC, 'Select * from InvoiceLine')

Use QB

TRUNCATE TABLE InvoiceLine

Insert InvoiceLine select * from #tempInvoiceLine

Drop Table #tempInvoiceLine

 

 

i used this script  from  http://www.qdeveloper.com.au/images/DatabaseTables.sql.txt  to create the SQL Table

CREATE TABLE [dbo].[InvoiceLine] (
[TxnID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TimeCreated] [datetime] NULL ,
[TimeModified] [datetime] NULL ,
[EditSequence] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TxnNumber] [int] NULL ,
[CustomerRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CustomerRefFullName] [varchar] (209) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ClassRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ClassRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ARAccountRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ARAccountRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TemplateRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TemplateRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TxnDate] [smalldatetime] NULL ,
[TxnDateMacro] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[RefNumber] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressAddr1] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressAddr2] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressAddr3] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressAddr4] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressCity] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressState] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressPostalCode] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BillAddressCountry] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressAddr1] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressAddr2] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressAddr3] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressAddr4] [varchar] (41) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressCity] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressState] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressPostalCode] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipAddressCountry] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IsPending] [bit] NULL ,
[IsFinanceCharge] [bit] NULL ,
[PONumber] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TermsRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TermsRefFullName] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DueDate] [smalldatetime] NULL ,
[SalesRepRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesRepRefFullName] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FOB] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipDate] [smalldatetime] NULL ,
[ShipMethodRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ShipMethodRefFullName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Subtotal] [decimal](11, 2) NULL ,
[ItemSalesTaxRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ItemSalesTaxRefFullName] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesTaxPercentage] [decimal](13, 5) NULL ,
[SalesTaxTotal] [decimal](11, 2) NULL ,
[AppliedAmount] [decimal](11, 2) NULL ,
[BalanceRemaining] [decimal](11, 2) NULL ,
[Memo] [varchar] (4095) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IsPaid] [bit] NULL ,
[CustomerMsgRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomerMsgRefFullName] [varchar] (101) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IsToBePrinted] [bit] NULL ,
[CustomerSalesTaxCodeRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomerSalesTaxCodeRefFullName] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SuggestedDiscountAmount] [decimal](11, 2) NULL ,
[SuggestedDiscountDate] [smalldatetime] NULL ,
[InvoiceLineType] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineSeqNo] [int] NULL ,
[InvoiceLineGroupTxnLineID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineGroupItemGroupRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineGroupItemGroupRefFullName] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineGroupDesc] [varchar] (4095) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineGroupQuantity] [decimal](13, 5) NULL ,
[InvoiceLineGroupIsPrintItemsInGroup] [bit] NULL ,
[InvoiceLineGroupTotalAmount] [decimal](11, 2) NULL ,
[InvoiceLineGroupSeqNo] [int] NULL ,
[InvoiceLineTxnLineID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineItemRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineItemRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineDesc] [varchar] (4095) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineQuantity] [decimal](13, 5) NULL ,
[InvoiceLineRate] [decimal](14, 5) NULL ,
[InvoiceLineRatePercent] [decimal](13, 5) NULL ,
[InvoiceLineClassRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineClassRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineAmount] [decimal](11, 2) NULL ,
[InvoiceLineServiceDate] [smalldatetime] NULL ,
[InvoiceLineSalesTaxCodeRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineSalesTaxCodeRefFullName] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineOverrideItemAccountRefListID] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InvoiceLineOverrideItemAccountRefFullName] [varchar] (159) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FQSaveToCache] [bit] NULL ,
[FQPrimaryKey] [varchar] (110) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CustomFieldInvoiceLineOther1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldInvoiceLineOther2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldInvoiceLineGroupOther1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldInvoiceLineGroupOther2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldInvoiceLineGroupLineOther1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldInvoiceLineGroupLineOther2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldOther] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldClient] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldConsultant] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldCustomerState] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldRate] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldReferenceID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldSIC] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomFieldTaskCode] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Any ideas .... Im at a loss

 

 

 
i really do need help, this computer stuff is like double dutch  
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-11-15 10:47:54

Your custom fields most likely don't match. Run:

sp_columns InvoiceLine

in VB Demo to see your actual table structure and modify the CREATE TABLE script to suit.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to