Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Scripterxf_ScripterSQL Script Generation and Processing
Public Function CreateDummyInsertStatement (
TableName As String,
AutoNumberValue As Long,
dbs As DAO.Database
) As String
Generate an insert statement to reset the autonumber for TableName.
Insert the passed value to the Autonumber column and use dummy values for all the other columns.
TableName as String
The name of the table to repair
AutoNumberValue as Long
The value to insert to the AutoNumber column
dbs as DAO.Database
(no description)
Call Template:
Dim s As String
s = xf.Scripter.CreateDummyInsertStatement(TableName, AutoNumberValue, dbs)
See Also:
Example 1:
CreateDummyInsertStatement "tblProduct", 1660