ODBCSetFilter
Constrains the records selected in a database.
| Function
| Group
| Execution
| Windows
| Embedded
| Thin Client
| Mobile Access
|
| ODBCSetFilter | ODBC
| Synchronous
| Supported
| Not supported
| Executed on Server
| Not supported
|
Syntax
- numHandler
- The handler returned by the ODBCOpen function.
- strFilter
- The a SQL WHERE clause.
Returned value
| 0
| Success
|
| 1
| Invalid handler
|
| 2
| Invalid parameter
|
Notes
You may find this function useful for selecting a subset of records, such as “all salespersons based in California” (“state = ‘CA’”). Remember to call ODBCQuery after calling this function.
Examples
| Tag Name
| Expression
|
| Tag
| ODBCSetFilter( 3, “Name=’Morgan’” ) |
ODBCSetFilter
