Constrains the records selected in a
database.
|
Function |
Group |
Execution |
Windows |
Embedded |
Thin Client |
| ODBCSetFilter
|
ODBC |
Synchronous |
Supported |
Not
supported |
Executed on
Server |
Syntax
ODBCSetFilter(numHandler,strFilter)
- 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'" )
|