Versions Compared

Key

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

[ Image Removed |../../index.htm#lansa/lceselect.htm]
You are here:

...

Select and retrieve specified fields from the file using the key list specified.

BOOL

LceSelect

(int

iSession,

 

 



 char far *

strFieldList,

 

 



 char far *

strFileName,

 

 



 char far *

strKeyList,

 

 



 BOOL

fGeneric,

 

 



 int far *

piRecordCount )

  
Parameters

iSession

The session identifier as returned by LceGetSessionId.

strFieldList

A list of fields to be retrieved from the file. Each of these fields must have been declared using an LceUseField function.

strFileName

The name of the file. This 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. Refer to the notes for key and generic search considerations.

fGeneric

Refer to the notes for further information.
True = apply a generic search.
False = do not apply a generic search.

piRecordCount

The number of records returned by the select.

  
Return Values
TRUE is returned if the session has selected records.
FALSE is returned if an error occurs.
Notes

Portability Considerations

An error will occur if you attempt to use a generic key which is numeric if you are using a Windows, Linux or other non-IBM i host system.

  
The characteristic of this LceSelect search can be specified using the LceSetSelectOptions function.
Note: You cannot use the *RECEIVEIMMED option with LceSelect.
This function is a simplified version of these functions:

...

Related Functions
6.64 LceSetSelectOptions
6.50 LceRequestSelect
6.49 LceReceiveSelect
6.51 LceRequestSelectWhere
6.37 LceGetRecordCount
6.38 LceGetSelect
6.11 LceDeleteSelect
[ Image Removed |../../index.htm#lansa/lceselect.htm]