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.
Replace the SELECT field list of a SQL statement variable
Replaces all fields in the SELECT clause with the fields supplied as arguments. Each non-empty argument becomes one selected field. Call ClearFieldList first if you want to guarantee a clean replacement.
| Parameter | Description |
|---|---|
| cmd | SQL statement variable name |
| Argument 0 | first field name |
| Argument 1 | second field name |
| Argument 2 | third field name, and so on for additional fields |
SqlStatement.SetFields "SQL statement variable name", "first field name", "second field name", "third field name, and so on for additional fields"