Re: Read-Only why ?

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

Article #666

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

#666

From: Michael Rotteck
Date: Sun, 02 Aug 1998 00:00

27 lines
1154 bytes

On Sat, 1 Aug 1998 19:30:59 +0200, "Roger Gilliar"
<rgilliar@mcs-hh.de> wrote:

Hi Roger,

why do you not read the VdB Knowledge Disk ? Look Index SQL and you
find the answer, SQL and index.

ORDER BY

when the field have an index you can read/write.

When the field have no index ORDER BY do a sort. And a sort table are
always read only.

>I tried a simple query:
>
>select * from test order by ip_byte_1, ip_byte_2
>
>When I send this query to my Oracle server everything works a expected. If I
>use instead a dbase table as my datasource I get a read-only result set.
>
>Why ? And what should I do if I'm using the query object and want a specific
>sorting order ?

--
Michael Rotteck

Technical Details

Message-ID: <35c4bdde.211468829@forums.borland.com>

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

References: <6pvjdr$ril6@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,420717107802b0ca
X-Google-Attributes: gidff5a1,public
From: 100277.441@compuserve.com (Michael Rotteck)
Subject: Re: Read-Only why ?
Date: 1998/08/02
Message-ID: <35c4bdde.211468829@forums.borland.com>
X-Deja-AN: 377274002
References: <6pvjdr$ril6@forums.borland.com>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message