Previous Topic

Next Topic

Inhoudsopgave

Book Index

InsertSQL Property

Property Property InsertSQL: string

Description

SQL statement to be executed when a record is added to the result set of the query with the Insert or Append function. A fixed format for date fields should be used: yyyy/mm/dd hh:mm:ss:ms.

Example

INSERT INTO T_Language

(langCode, Description, LangID, LastUpdatedOn, LastUpdatedBy)

VALUES ("EN", "English", 1, "2010/02/04 13:04:10:859", "ISAH")