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 Advisor
Member - American Institute of Professional Bookkeepers
Brainbench Certified in Financial Accounting, Bookkeeping and Payroll

8350 Archibald Ave. Ste. 230
Rancho Cucamonga, CA 91730
Tel: (909) 972-3051
Fax: (909) 972-6916
Email: rnoche@...
Web: www.diskmate.net

<http://www.diskmate.net/diskmate%20map.bmp> Office Map



From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
lkside79
Sent: Tuesday, June 02, 2009 7:59 PM
To: qodbc@yahoogroups.com
Subject: [qodbc] INSERT INTO Query Problem








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,BillAddressCi
ty,BillAddressState,BillAddressPostalCode,PONumber,SalesOrderLineItemRefFull
Name,SalesOrderLineQuantity,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





[Non-text portions of this message have been removed]