FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Use of "(" ")" in the indexkey
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 06:44 AM

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
Posts: 76
Joined: Fri Dec 30, 2005 10:25 AM
Re: Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 07:00 AM

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
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 08:14 AM
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
Posts: 90
Joined: Wed Nov 07, 2007 08:56 AM
Re: Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 08:37 AM
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 :-)
3. xHarbour
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 12:38 PM

Enrico,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Use of "(" ")" in the indexkey
Posted: Tue Jun 03, 2014 01:47 PM
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
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Re: Use of "(" ")" in the indexkey
Posted: Wed Jun 04, 2014 08:08 AM

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. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Use of "(" ")" in the indexkey
Posted: Wed Jun 04, 2014 08:15 AM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 80
Joined: Tue Mar 25, 2008 09:03 PM
Re: Use of "(" ")" in the indexkey
Posted: Wed Jun 04, 2014 09:02 AM
  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

Continue the discussion