[QODBC-Desktop] How to insert data into the TimeTracking table using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
|
|
An Example of Creating a TimeTracking RecordNote: 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. Create a Simple TimeTrackingINSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName", Create a TimeTracking with Long NotesThis INSERT statement is a Time/Enter Single Activity entry with a very long "Notes" column/field with QuickBooks 2006 : INSERT INTO "TimeTracking" ("EntityRefListID", "DurationMinutes","TxnDate","CustomerRefFullName","ItemServiceRefFullName", Result in VB Demo Result in QuickBooks 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:
Data LocationEntityRefListID Location I used the "EntityRefListID" value of '370000-933272659' because it's the ListID for employee Dan T. Miller. EntityRefListID can be found in the Entity table by doing: SELECT ListID, FullName, IsActive, Type FROM Entity or, in my case to check that '370000-933272659' is a valid "EntityRefListID": SELECT ListID, FullName, IsActive, Type FROM Entity where ListID='370000-933272659'
Keywords: Tracking | |
|