Das deutschsprachige Forum für Entwickler in der Xbase-Welt, ein Angebot des Deutschsprachige Xbase-Entwickler e. V.
https://www.xbaseforum.de/
Aus der VFP9-Hilfe zum INDEX-Befehl:... ohne knallt es bei der Erzeugung des Indexes schon bei über ca. 120 Zch.
CDXDBE (ORDER Komponente)
Max. length for both
INDEX plus FOR expression 512 characters
Code: Alles auswählen
DbeSetDefault("FOXCDX")
IF DbeBuild( "FOXCDX", "FOXDBE", "CDXDBE" )
DbeInfo(COMPONENT_DATA,FOXDBE_LOCKRETRY,1000000)
DbeInfo(COMPONENT_DATA,FOXDBE_LOCKDELAY,10)
DbeInfo(COMPONENT_DATA, FOXDBE_LIFETIME, 0)
DbeInfo(COMPONENT_ORDER,CDXDBE_LOCKRETRY,1000000)
DbeInfo(COMPONENT_ORDER,CDXDBE_LOCKDELAY,10)
DbeInfo(COMPONENT_ORDER, FOXDBE_LOCKMODE, LOCKING_EXTENDED)
ENDIF
Bytes != Zeichen
The following restrictions apply to the CDXDBE:
- maximum key-expression size plus for-expression size if 512 byte.
This means your key-expression can be at max. 512 bytes if no
for expession is given. Or in other words both expession share
the same storage location which has a maximum size of 512 bytes.
- maximum key-value length is 240 bytes. This implicates that if
you have a collation table active the size in characters of your
key-value is limited to 120 chars - this is bec. the CDXDBE
collation table transforms the key-value by expanding each
character into 2 bytes. If collation is ASCII or CDXDBE_MODE
is FOXPRO2X, no transformation occurs and the key-value size
is restricted to 240 characters.
Hm, meine DBFs sind ASCII, also müssten doch 240 Zeichen möglich sein ?If collation is ASCII or CDXDBE_MODE
is FOXPRO2X, no transformation occurs and the key-value size
is restricted to 240 characters.