Page History
[ |../../index.htm#lansa/lcerequestselectwhere.htm]
You are here:
...
Identifies one or more records matching the search criteria in a file on the host. No data is transferred from the host.
BOOL | LceRequestSelectWhere | (int | iSession, |
char * | strFieldList, |
char * | strFileName, |
char * | strKeyList, |
char * | strConditions, |
BOOL | fGeneric) |
Parameters
iSession | The session identifier. |
strFieldList | A list of field names. All fields must have been declared using an LceUseField function. |
strFileName | The name of the file. This file must have been declared using an LceUseFile function |
strKeyList | A list of key field names. These key fields must have been declared using the LceUseField function. The values for the keys are set using the LceSetFieldValue/ LceSetFieldValueU function. |
strConditions | The 'Where' clause used for the select. Refer to the notes for more information, including how to correctly use DateTime field values. |
fGeneric | Refer to the notes for more information. |
Return Values
TRUE is returned if the session can select records.
FALSE is returned if an error occurs.
Notes
The Where clause, specified in strConditions, must conform to the rules defined for Expression format and definition in Specifying Conditions and Expressions in the LANSA Technical Reference Guide.
...
Remember that the LANSA Open functions are primarily designed to act as high performance "back ends" to programmer designed and implemented applications, not to be generic end user query tools by themselves.
Related Functions
6.64 LceSetSelectOptions
6.45 LceLocalDateTimeToServer
6.67 LceUnicodeToHex
6.49 LceReceiveSelect
6.48 LceReceiveNextX
6.37 LceGetRecordCount
6.38 LceGetSelect
6.53 LceSelect
6.11 LceDeleteSelect
[ |../../index.htm#lansa/lcerequestselectwhere.htm]