Trying to take the advice of the wise sages on this forum, I am not going to continue to use the NewRecord class and instead use the SQL INSERT INTO… Command.
But I’m have trouble with dates and booleans.
TransactionDate is a table field defined as DATE. TransDate is a DATE variable.
sSQL = "SQL INSERT INTO TestTable (TransactionDate, Posted) Value (" + TransDate + ", " + bPosted + ")"
How do I specify a Date field and Boolean field in the values list?