Search the web
Sign In
New User? Sign Up
qodbc · QODBC ODBC Driver for QuickBooks
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
INSERT INTO Query Problem   Message List  
Reply | Forward Message #1347 of 1356 |
I'm using the QODBC Server 9.0 Driver and trying to perform the following query.
I have looked at it to long and need some else to look please help.

Everytime I try some version of this I get this error - Invalid operand for
operator: <assignment>

INSERT INTO SalesOrderLine
(CustomerRefFullName,TxnDate,BillAddressAddr1,BillAddressAddr2,BillAddressCity,B\
illAddressState,BillAddressPostalCode,PONumber,SalesOrderLineItemRefFullName,Sal\
esOrderLineQuantity,SalesOrderLineRate,FQSaveToCache) VALUES ('BED, BATH AND
BEYOND','2009-05-31','650 LIBERTY AVE','ANNEX
BLDG','UNION','NJ','07083','VM24860','38-512','6','4.22',1)

Thank you for any help,

Cory






Wed Jun 3, 2009 2:58 am

lkside79
Offline Offline
Send Email Send Email

Forward
Message #1347 of 1356 |
Expand Messages Author Sort by Date

I'm using the QODBC Server 9.0 Driver and trying to perform the following query. I have looked at it to long and need some else to look please help. Everytime...
lkside79
Offline Send Email
Jun 13, 2009
9:06 am

cory my guess is the comma inside the first field. Our technical support system is best staffed by those who can help with this question, please see the FAQ...
Brad
flexq
Offline Send Email
Jun 13, 2009
9:22 am

Try using {d'2009-05-31'} format on the TxnDate field. Robert Noche Diskmate Bookkeeping and Tax Services CTEC Registered Tax Preparer Certified Quickbooks Pro...
Robert Noche
rnoche
Offline Send Email
Jun 14, 2009
5:36 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help