Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../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.
Field (i.e. column) names may be specified in upper or lower case.
Field names do NOT begin with "#" (hash/pound) signs.
This list may refer to any fields from the specified file. Fields may be real or virtual.

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.
Key fields must not be specified if the *BLOCKBYKEY option was used in the preceding LceSetSelectOptions.
Refer to the notes before using these key fields.

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.
True = apply a generic search.
False = do not apply a generic search.

  
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
[ Image Removed |../../index.htm#lansa/lcerequestselectwhere.htm]