Hi,
I am having problem doing an insert into the Check table. The Sql statement is below. Can you see an problems with my approach?
INSERT INTO Check (AccountRefListID,AccountRefFullName,PayeeEntityRefListID,PayeeEntityRefFullName,RefNumber,TxnDate, Memo,AddressAddr1,AddressAddr2,AddressAddr3,AddressAddr4,AddressCity,AddressCounty,AddressPostalCode,AddressCountry, IsToBePrinted,AmountIncludesVAT)VALUES ( '160000-1120441942','Unallocated Funds','810000-1122516863','aaa','CC20.27', '21/03/2007 11:02:01 PM','Credit Card Clearing-ST_Jan/2007-PN99-:CC','','','','','','','','',0,0)
The error message I am getting is :
ERROR [42S00] [QODBC] Invalid operand for operator: <assignment>
Thank-you,
dan
|