I am setting up some Crystal reports that connect to a Btrieve 6.x data set using an ODBC from Pervasive 8.5.
Retrieveing data is no problem. Works great. But I have a need to add some rows to the Btrieve data that include a DATE field. I am using the Pervasive SQL DAta Manager to do the insert.
This is my SQL statement:
INSERT INTO "NLTXDH" ("Acct", "TransactionType", "Description", "TransactionAmt", "EntryDate") VALUES ('42000000','B01','Budget - 2005','-100.00',20050101)
It fails on the date every time. I have change the datae format to the following and still no luck:
None of these worked...
If anyone can help, I would be grateful to say the least... and a little less bald....