void ddlFind( CONTROL *ctl, char *OptnStr, char *ArgList);Permitted values in OptnStr:
/Cn - return first n values only /F - enable field-to-field query /K - case sensitive find (non-keyed only) /N - force non-keyed query
Form of ArgList:
<cx> [<TableName>]
[WHERE] <expression>
Where: |
<cx> is the name of the collection <TableName> is the name of the target table. If <TableName> is omitted, the global collection is used. <query-expression> has the form: <condition1> {AND OR XOR EXCEPT} <condition2> ... <conditionN> <conditionN> can be prefixed with the NOT operator in either a unary or binary context; <conditionN> can be any one of the following: cxN - i.e., the name of a collection; fieldN OP valueN; fieldN OP %variableN; %variableN OP valueN; fieldN OP fieldN' (if /N option is present); #SavedCollection - i.e., the name of a saved collection cxN TableNameN - refer to Note 6) below |
The ddlFind() API function isolates the subset of interest into a specified collection.
The <query-expression> determines the subset of interest.
If the <TableName> argument is specified, the function operates only on the specified table, and the specified part of the collection. If the <TableName> argument is not specified, the function operates only on all tables, and the global collection. The query value for a DATE field can be in either the default external format 'mm/dd/yyyy', 'mm-dd-yyyy' or 'mm.dd.yyyy'; or it can be in the system DATE format 'yyyymmdd'. That is, the only valid forms for a date literal in ddlFind() are: 'yyyymmdd' 'mm/dd/yyyy' or 'mm/dd/yy' 'mm-dd-yyyy' or 'mm-dd-yy' 'mm.dd.yyyy' or 'mm.dd.yy' The query value for a DATETIME field can be in either the default external format 'mm/dd/yyyy hh:nn:ss.ttt', 'mm-dd-yyyy hh:nn:ss.ttt' or 'mm.dd.yyyy hh:nn:ss.ttt'; or it can be in the system DATETIME format 'yyyymmddhhnnssttt'. The query value for a DateTimeEx or TIME field must be in the default format as specified in the Default Templates section. In all cases, the default template can be modified with the ddlMode() DATEFORM function. The query value for a BYTE field is expressed as a hex character string in the form 0xnnnnnnn ... Refer to ddlFind() - additional details and examples for additional information. |
|
|
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.