The following INSERT commands work on the QuickBooks 2005 or 2006 USA Edition Sample Rock Castle Construction Company file using QODBC v6.00.00.143 or later. Modify the actual data elements to match your system.
INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName",
"PayrollItemWageRefFullName") VALUES ( '370000-933272659', 480, {d'2007-12-18'}, 'Pretell Real Estate:75 Sunset Rd.', 'Removal','Salary')
This INSERT statement is for a Time/Enter Single Activity entry with a very long "Notes" column/field with QuickBooks 2006 :-
INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName",
"PayrollItemWageRefFullName","Notes") VALUES ( '370000-933272659', 480, {d'2007-12-19'}, 'Pretell Real Estate:75 Sunset Rd.', 'Removal','Salary','QODBC Driver for QuickBooks New Version 6.0 with Optimizer Technology. A fully functional ODBC driver for reading and writing QuickBooks 2006-2002 accounting data files by using standard SQL queries. The new version 6.0 adds Optimizer technology which is 10 times faster than using the QuickBooks SDK directly. Many applications have ODBC support built-in and can automatically use QuickBooks data with wizard ease once this driver has been installed. Applications such as Microsoft Access - Excel - Visual Basic or Crystal Reports will immediately have real-time data access to your critical accounting data.' )
Note: The "Notes" column has a limit of 4095 characters and the text cannot contain any , (commas).
The screen dump (below) shows the Time/Enter Single Activity entry with a very long "Notes" column/field as it appears QuickBooks 2006 after executing the SQL statement :-
|
