BOOL fOK;
int  iSession;
int  iCount;
char szOrderStartDate[ DATETIME_LEN ];
char szWhereClause[ 256 ];

fOK = LceSetSelectOptions(iSession, "*BLOCKBYRRN");
fOK = LceLocalDateTimeToServer(iSession, "ORDRTIME", szOrderStartDate)
sprintf( szWhereClause, "ORDRTIME > %s", szOrderStartDate );
fOK = LceRequestSelectWhere(iSession,
          "ORDERNUM, ORDRTIME", "ORDERS", "", szWhereClause, FALSE);

fOK = LceReceiveSelect(iSession, "ORDERS");
fOK = LceGetRecordCount(iSession, "ORDERS", &iRecords);
for (iCount=0; iCount < iRecords; i++)
{
        fOK = LceGetSelect(iSession, "ORDERS", iCount, "ORDERNUM, ORDRTIME");
}
  • No labels