Re: Index composed

Article View: borland.public.vdbase.data.sql

Article #57

Back to borland.public.vdbase.data.sql Previous Next

#57

From: Romain Strieff [TeamB]
Date: Fri, 19 Mar 1999 00:00

15 lines
906 bytes

In article <7csov0$acc11@forums.borland.com>, Andrea politely paraphrased 
...
> How i can do for create an index on 2 filelds of a table; the first fields
> is LONG type (userID) and the second fields is CHARATER type (nameID).

Index on str(userid,10,0,"0")+nameid tag mytag


Naturally you'd also need a such a one (of type character) for the 
_parent_ or it wouldn't be possible to relate the 2 tables.

Index on str(userid,10,0,"0") tag mytag

-- 
Romain Strieff [dBVIPS]

Technical Details

Message-ID: <MPG.115c3803b612b5d998a09a@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <7csov0$acc11@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2c61bb8d2edf0b15
X-Google-Attributes: gidff5a1,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: Index composed
Date: 1999/03/19
Message-ID: <MPG.115c3803b612b5d998a09a@forums.inprise.com>
X-Deja-AN: 456430866
References: <7csov0$acc11@forums.borland.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message