🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Problem with Order Tag on SQL Tables

#1441
From: Ken Chan
Date: Wed, 24 Dec 1997 00:00
26 lines
1535 bytes
Romain Strieff [TeamB] wrote:

> Just reread an older BDE users guide where it says dBase _only_ 
> supports expression indexes.

Well, that's true too. All DBF indexes, including single-field indexes, 
are really expression indexes. For a single field, the value of the 
expression is just the value of that field. IOW, "a distinction without a 
difference."

> As you seem to move into the SQL direction, why not allow then 254 wide 
> indexes on fields of that size for level 7 tables, all the SQL servers 
> seem to do it?

I'm not sure there is room in the NDX/MDX format for that, and still 
maintain backward compatibility.

> How about an example of DBISetRange() ?<G>

In my quick look at that function, you need to pass a few pointers, so 
that won't be as easy to do at the moment... ask me next year <g>

-- 
//Ken[0]@Borland
<Please follow-up to newsgroup; do not reply to email>
Technical Details
Message-ID: <MPG.f0b3c6867b8bb40989680@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bd0a7b$56007e50$74ffc2d0@wells> <MPG.f01fde638bbf0e98975b@forums.borland.com> <MPG.f02971e4f5ae88898a1f0@forums.borland.com> <MPG.f037b20d04f7ac8989763@forums.borland.com> <MPG.f0457cdca73d4a98a242@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,3ddd9c9af1c9a349
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Ken Chan)
Subject: Re: Problem with Order Tag on SQL Tables
Date: 1997/12/24
Message-ID: <MPG.f0b3c6867b8bb40989680@forums.borland.com>
X-Deja-AN: 310038649
References: <01bd0a7b$56007e50$74ffc2d0@wells> <MPG.f01fde638bbf0e98975b@forums.borland.com> <MPG.f02971e4f5ae88898a1f0@forums.borland.com> <MPG.f037b20d04f7ac8989763@forums.borland.com> <MPG.f0457cdca73d4a98a242@forums.borland.com>
Organization: Borland
Newsgroups: borland.public.vdbase.data.sql