Page History
C Example 1
Set characteristics for a select search:BOOL fOK
BOOL fOK;
int iSession;
...
fOK = LceSetSelectOptions(iSession,
...
"*BACKWARDS, *MAXREC25");
...
fOK = LceRequestSelect(iSession,
...
"SURNAME,
...
SALARY",
...
"PSLMST",
...
"",
...
FALSE);
...
fOK = LceReceiveSelect(iSession,
...
"PSLMST");
...
fOK = LceGetRecordCount(iSession,
...
"PSLMST",
...
&iRecords);
...
for (iCount=0;
...
iCount < iRecords; i++)
{
...
fOK = LceGetSelect(iSession,
...
"PSLMST",
...
iCount,
...
"SURNAME,
...
SALARY");
}
...
C Example 2
Lock a record during a fetch:BOOL fOK
BOOL fOK;
int iSession;
...
fOK = LceSetSelectOptions(iSession,
...
"*LOCK");
...
fOK = LceSetFieldValue(iSession,
...
"EMPNO",
...
"12345");
...
fOK = LceFetch(iSession,
...
"SURNAME,
...
GIVENAME",
...
"PSLMST",
...
"EMPNO");
...
C Example 3
Use *RECEIVEIMMED to Select Records:BOOL fOK
BOOL fOK;
int iSession;
...
long lFlags;
...
fOK = LceSetSelectOptions(iSession,
...
"*RECEIVEIMMED");
...
fOK = LceRequestSelect(iSession,
...
"SURNAME,
...
SALARY",
...
"PSLMST",
...
"",
...
FALSE);
...
fOK = LceReceiveNextX(iSession,"",0,NULL,0);
...
fOK = LceGetFieldValueX(iSession,
...
"SURNAME",
...
strSurname,
...
lFlags);
...
fOK = LceGetFieldValueX(iSession,
...
"SALARY",
...
strSalary,
...
lFlags);
...
C Example 4
Use blocking by key:BOOL fOK
BOOL fOK;
int iSession;
...
fOK = LceSetSelectOptions(iSession,
...
"*BLOCKBYKEY");
...
fOK = LceRequestSelect(iSession,
...
"SURNAME,
...
SALARY",
...
"PSLMST",
...
"",
...
FALSE);
...
fOK = LceReceiveSelect(iSession,
...
"PSLMST");
...
fOK = LceGetRecordCount(iSession,
...
"PSLMST",
...
&iRecords);
...
for (iCount=0;
...
iCount < iRecords; i++)
{
...
fOK = LceGetSelect(iSession,
...
"PSLMST",
...
iCount,
...
"SURNAME,
...
SALARY");
}