>>ITEM: R00115
>>DATE: 09/18/96
>>TYPE: Information
>>TITLE: Functions that can be used with RaSQL/B INDEX ON expression
>>PRODUCT(S):
RaSQL/B 6.1x for Clipper
>>PLATFORM(S):
>>SUMMARY:
The following list of functions are those which can be used in a
RaSQL/B "INDEX ON" expression.
>>MORE INFORMATION:
RaSQL/B "INDEX ON" expressions can contain only those built-in
Clipper functions that are specifically for the concatenation of
fields of different data types. These include:
DTOS() for DATE fields
STR() for NUMERIC fields
IFF() for LOGICAL fields
The following fields are also acceptable:
- DESCEND() for descending indexes
- UPPER() for uppercase (case insensitive) indexes
User-defined functions (UDFs) and other Clipper functions
are ignored or will generate an error.
This applies only to files opened with the RDD (i.e., USE or
DBUSEAREA). It does not apply to files opened with N_XUSE.
>>RESOLUTION/FIX:
>>EXAMPLE(S):
The following examples are acceptable:
-
INDEX ON NAME+DTOS(DATE)
- INDEX ON DESCEND(STR(NUMBER))+DTOS(DATE)+UPPER(NAME)
- INDEX ON UPPER(DESCEND(NAME))
The following examples are unacceptable.They will be ignored
(i.e., the base field name will be used instead) or they will
generate an error:
- INDEX ON MYUDF(NAME)+DTOS(DATE) // contains a UDF
- INDEX ON STRTRAN(NAME," ","") // not for concatenation
>>SEE ALSO:
>>COPYRIGHT 1997 Communication Horizons
All rights reserved worldwide.
No distribution without specific consent of publisher.
Knowledgebase
Top Home
