Is someone using parentheses "(" ")" in the index key definition ?
If so:
1. What RDD are you using ?
2. What is your index key ?
3. Are you using Harbour or xharbour ?
thanks
Use of "(" ")" in the indexkey
- Antonio Linares
- Site Admin
- Posts: 37481
- Joined: Thu Oct 06, 2005 5:47 pm
- Location: Spain
- Contact:
Re: Use of "(" ")" in the indexkey
Yes, I do it for many years. I use DBFNTX and xHarbour.
Here an example
aKey := {"Kunde+Konto+DTOS(Datum)+STR(Nummer)" ,; "1"
"DTOS(Datum)+STR(Nummer)" ,; // "2"
"Konto+DTOS(Datum)+STR(Nummer)" ,; // "3"
"STR(Nummer,6,0)+DTOS(Datum)" ,; // "4"
"PADR(UPPER(TRIM(Text1)+TRIM(Text2)),50,' ')",; // "5"
"STR(ABS(Soll+Haben),12,2)" ,; // "6"
"Kunde_2+Konto+DTOS(Datum)+STR(Nummer)" ,; // "7"
"IIF(EMPTY(Haben),Konto+Gegenkonto,Gegenkonto+Konto)"} // "8"
Here an example
aKey := {"Kunde+Konto+DTOS(Datum)+STR(Nummer)" ,; "1"
"DTOS(Datum)+STR(Nummer)" ,; // "2"
"Konto+DTOS(Datum)+STR(Nummer)" ,; // "3"
"STR(Nummer,6,0)+DTOS(Datum)" ,; // "4"
"PADR(UPPER(TRIM(Text1)+TRIM(Text2)),50,' ')",; // "5"
"STR(ABS(Soll+Haben),12,2)" ,; // "6"
"Kunde_2+Konto+DTOS(Datum)+STR(Nummer)" ,; // "7"
"IIF(EMPTY(Haben),Konto+Gegenkonto,Gegenkonto+Konto)"} // "8"
Frank-Peter
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Use of "(" ")" in the indexkey
Antonio,
EMG
Yes.Antonio Linares wrote:Is someone using parentheses "(" ")" in the index key definition ?
DBFCDX (FPT)Antonio Linares wrote:If so:
1. What RDD are you using ?
Various. What do you want to know, exactly?Antonio Linares wrote:2. What is your index key ?
xHarbour.Antonio Linares wrote:3. Are you using Harbour or xharbour ?
EMG
Re: Use of "(" ")" in the indexkey
1. DBFCDX (FPT)Antonio Linares wrote:Is someone using parentheses "(" ")" in the index key definition ?
If so:
1. What RDD are you using ?
2. What is your index key ?
3. Are you using Harbour or xharbour ?
thanks
2. dToS(), StrZero(), Str(), Upper(), Year(), Left() etc etc
3. xHarbour
- Antonio Linares
- Site Admin
- Posts: 37481
- Joined: Thu Oct 06, 2005 5:47 pm
- Location: Spain
- Contact:
Re: Use of "(" ")" in the indexkey
Enrico,
If you are using parentheses then yes, please (just some of them)
If you are using parentheses then yes, please (just some of them)
- Enrico Maria Giordano
- Posts: 7355
- Joined: Thu Oct 06, 2005 8:17 pm
- Location: Roma - Italia
- Contact:
Re: Use of "(" ")" in the indexkey
Antonio,
EMG
I'm using the same our friends have already reported.Antonio Linares wrote:Enrico,
If you are using parentheses then yes, please (just some of them)
EMG
Re: Use of "(" ")" in the indexkey
Yes, I am using parantheses in index key definitions.
1. I'm using DBFCDX RDD
2. Example of an index key : UPPER(PRDOSSIER)+STR(100000000-VAL(DTOS(PRDATUM)),9,0)+STR(10000000-RECNO(),8,0)
3. xHarbour Builder
1. I'm using DBFCDX RDD
2. Example of an index key : UPPER(PRDOSSIER)+STR(100000000-VAL(DTOS(PRDATUM)),9,0)+STR(10000000-RECNO(),8,0)
3. xHarbour Builder
Regards,
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
Michel D.
Genk (Belgium)
_____________________________________________________________________________________________
I use : FiveWin for (x)Harbour v. 21.01 - Harbour 3.2.0 (October 2020) - xHarbour Builder (January 2020) - Bcc7
- Antonio Linares
- Site Admin
- Posts: 37481
- Joined: Thu Oct 06, 2005 5:47 pm
- Location: Spain
- Contact:
Re: Use of "(" ")" in the indexkey
Many thanks to all of you for your great feedback
Re: Use of "(" ")" in the indexkey
1. I'm using DBFNTX RDD
2. Example of an index key : index on arcdgia->dggia to "TEMPPRA" for (year(arcdgia->dggia) = cannogia ) MEMORY
3. xHarbour Builder
Stefano
2. Example of an index key : index on arcdgia->dggia to "TEMPPRA" for (year(arcdgia->dggia) = cannogia ) MEMORY
3. xHarbour Builder
Stefano
FWH 14.11 + xHarbour + bcc582