hello, I run the following commands to create a deposit using QODBC (latest server edition) working with QB 2008 Canadian Edition.
However, it returns no "result rows" as I paste each line succesively into the VB DEMO and when I check quickbooks my QB application after the final deposit insert is executed I can find no reference to the deposite ... its as though it disappeared.
Help and thanks ....
Brett
insert into DepositLine (DepositLineCheckNumber, DepositLinePaymentMethodRefListID, DepositToAccountRefListID, DepositLineMemo, DepositLineAmount, DepositLineEntityRefListID, FQSaveToCache) values ('cheque?', '20000-1168461108', '350001-1168461468', '202084', 111.87, '6B0000-1182893776' , 1)
insert into DepositLine (DepositLineCheckNumber, DepositLinePaymentMethodRefListID, DepositToAccountRefListID, DepositLineMemo, DepositLineAmount, DepositLineEntityRefListID, FQSaveToCache) values ('unknown', '20000-1168461108', '350001-1168461468', '201987', 111.87, '780000-1193060728' , 1)
insert into DepositLine (DepositLineCheckNumber, DepositLinePaymentMethodRefListID, DepositToAccountRefListID, DepositLineMemo, DepositLineAmount, DepositLineEntityRefListID, FQSaveToCache) values ('cheque?', '20000-1168461108', '350001-1168461468', '201915', 4520, '230000-1176165344' , 1)
insert into DepositLine (DepositLineCheckNumber, DepositLinePaymentMethodRefListID, DepositToAccountRefListID, DepositLineMemo, DepositLineAmount, DepositLineEntityRefListID, FQSaveToCache) values ('cheque?', '20000-1168461108', '350001-1168461468', '201831', 111.87, 'BD0000-1199977799' , 1)
insert into deposit (DepositToAccountRefListID, TxnDate, Memo) values ('350001-1168461468', {d'2008-06-29'}, '100' )
|