We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Execute collected SQL and bulk insert, update, or delete the results into a table
Runs the SQL accumulated between TEXT and ENDTEXT and passes the result set to the SqlInsertUpdate engine, which handles NextID allocation, created/modified date stamping, and user tracking automatically. Business rules are bypassed, so this is best suited for high-performance bulk loads, ASA imports, or temp-table operations where speed matters more than rule enforcement.
| Parameter | Description |
|---|---|
| cmd | Target table name (can be a temp table) |
| Argument 0 | Key field name(s), comma-separated, used to match existing rows |
| Argument 1 | Mode: InsertUpdate, InsertGuaranteed, Update, or Delete |
ExecuteTextToTable "Target table name (can be a temp table)", "Key field name(s), comma-separated, used to match existing rows", "Mode: InsertUpdate, InsertGuaranteed, Update, or Delete"