Re: SQL statement w/sum()

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

Article #646

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

#646

From: Christopher F. Neumann
Date: Mon, 27 Jul 1998 00:00

20 lines
1404 bytes

I guess the part that is missing is 'an error saying that the table is
readonly', and then kicks out without a result.  My intention IS just a
readonly access, but not an error and then denying access.

Steve Koterski wrote in message <35c4b90c.7627186@forums.inprise.com>...
>On Mon, 27 Jul 1998 10:47:42 -0500, "Christopher F. Neumann"
><CNeumann@Physix.com> wrote:
>
>>What causes a SQL statement to get a table as readonly if you run the
>>following:
>>
>>        select sum(myfield) from mytable
>>
>>BUT, if it is in a SQL file, no problem!
>
>*All* queries that aggregate data should be read-only. You are, after all,
>combining the values of multiple rows into one. Which of those multiple
>rows would you have updated by changes in the query result set? How should
>a sum of your MyField column values be editable (as it is a total and not
>an actual column value)?

Technical Details

Message-ID: <6pigq3$94517@forums.borland.com>

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

References: <6pi7gb$93q5@forums.borland.com> <35c4b90c.7627186@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,8171ca373096da47
X-Google-Attributes: gidff5a1,public
From: "Christopher F. Neumann" <CNeumann@Physix.com>
Subject: Re: SQL statement w/sum()
Date: 1998/07/27
Message-ID: <6pigq3$94517@forums.borland.com>
X-Deja-AN: 375388040
References: <6pi7gb$93q5@forums.borland.com> <35c4b90c.7627186@forums.inprise.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Physix, Inc.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message