FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Alias in index expression
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Alias in index expression
Posted: Mon Sep 11, 2006 01:25 PM

Is there an advantage of using an ALIAS in the index-expression:
index on kasse->beleg tag k_beleg
or
index on beleg tag k_beleg

Thanks in advance
Otto

Posts: 840
Joined: Thu Oct 13, 2005 07:05 PM
Re: Alias in index expression
Posted: Mon Sep 11, 2006 03:35 PM
Otto wrote:Is there an advantage of using an ALIAS in the index-expression:
index on kasse->beleg tag k_beleg
or
index on beleg tag k_beleg

Thanks in advance
Otto


None at all, in fact, you should avoid the use of use of alias in index expressions, specially if you are using Advantage Database Server, or if you are working with dynamic aliases.
Saludos

R.F.
Posts: 842
Joined: Mon Oct 10, 2005 01:29 PM
Alias in index expression
Posted: Mon Sep 11, 2006 04:47 PM

I use

index on field->beleg tag k_beleg

so I not declare the FIELD

Maurizio

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Alias in index expression
Posted: Mon Sep 11, 2006 05:28 PM

Rene, thank you for your answer. Advantage is my problem therefore I have to change. I couldn't remember why I used the Alias.

Hello Maurizio,
I was very happy to see you and your family here in Sillian.
The evening was too short.
Greetings from all of us
Otto

Continue the discussion