Use of "(" ")" in the indexkey

Post Reply
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Use of "(" ")" in the indexkey

Post by Antonio Linares »

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 :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
fp
Posts: 76
Joined: Fri Dec 30, 2005 10:25 am
Location: Germany

Re: Use of "(" ")" in the indexkey

Post by fp »

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"
Frank-Peter
User avatar
Enrico Maria Giordano
Posts: 7355
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Contact:

Re: Use of "(" ")" in the indexkey

Post by Enrico Maria Giordano »

Antonio,
Antonio Linares wrote:Is someone using parentheses "(" ")" in the index key definition ?
Yes.
Antonio Linares wrote:If so:

1. What RDD are you using ?
DBFCDX (FPT)
Antonio Linares wrote:2. What is your index key ?
Various. What do you want to know, exactly?
Antonio Linares wrote:3. Are you using Harbour or xharbour ?
xHarbour.

EMG
Patrizio
Posts: 90
Joined: Wed Nov 07, 2007 8:56 am
Location: Italy
Contact:

Re: Use of "(" ")" in the indexkey

Post by Patrizio »

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 :-)
1. DBFCDX (FPT)
2. dToS(), StrZero(), Str(), Upper(), Year(), Left() etc etc :D
3. xHarbour
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Use of "(" ")" in the indexkey

Post by Antonio Linares »

Enrico,

If you are using parentheses then yes, please (just some of them) :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Enrico Maria Giordano
Posts: 7355
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Contact:

Re: Use of "(" ")" in the indexkey

Post by Enrico Maria Giordano »

Antonio,
Antonio Linares wrote:Enrico,

If you are using parentheses then yes, please (just some of them) :-)
I'm using the same our friends have already reported.

EMG
User avatar
driessen
Posts: 1239
Joined: Mon Oct 10, 2005 11:26 am
Location: Genk, Belgium

Re: Use of "(" ")" in the indexkey

Post by driessen »

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
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
User avatar
Antonio Linares
Site Admin
Posts: 37481
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Contact:

Re: Use of "(" ")" in the indexkey

Post by Antonio Linares »

Many thanks to all of you for your great feedback :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
stefano
Posts: 80
Joined: Tue Mar 25, 2008 9:03 pm
Location: ITALIA

Re: Use of "(" ")" in the indexkey

Post by stefano »

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
FWH 14.11 + xHarbour + bcc582
Post Reply