Alias in index expression

Alias in index expression

Postby Otto » Mon Sep 11, 2006 1: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
User avatar
Otto
 
Posts: 6332
Joined: Fri Oct 07, 2005 7:07 pm

Re: Alias in index expression

Postby R.F. » Mon Sep 11, 2006 3: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.
R.F.
 
Posts: 840
Joined: Thu Oct 13, 2005 7:05 pm

Postby Maurizio » Mon Sep 11, 2006 4:47 pm

I use

index on field->beleg tag k_beleg

so I not declare the FIELD

Maurizio
User avatar
Maurizio
 
Posts: 824
Joined: Mon Oct 10, 2005 1:29 pm

Postby Otto » Mon Sep 11, 2006 5: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
User avatar
Otto
 
Posts: 6332
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 85 guests