Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Scripterxf_ScripterSQL Script Generation and Processing
Public Function ProcessSQLCommand (
SqlCommandText As String,
ParseOnly As Boolean,
dbs As DAO.Database,
Optional AddNewTablesToLinker As Boolean = False
) As String
Process an individual SQL command or statement This is not recommended for external use - pass the command to ProcessScript
SqlCommandText as String
The SQL command or statement text
ParseOnly as Boolean
Run in parse mode only (each command is processed twice: first, parsing for correct syntax and grammar only, then second, parsing and executing.
dbs as DAO.Database
The database object to run the script against, or Nothing
Optional AddNewTablesToLinker as Boolean = False
(no description)
Call Template:
Dim s As String
s = xf.Scripter.ProcessSQLCommand(SqlCommandText, ParseOnly, dbs)
s = xf.Scripter.ProcessSQLCommand(SqlCommandText, ParseOnly, dbs, AddNewTablesToLinker)
See Also:
Example 1:
Set recs = xf.DbConnect.OpenDAORecordset("xf_tblErrorLogLocal")
WereErrors = Scripter.ProcessScript(sqlStr, dbs, cn, recs, "Test Script")