Re: SELECT command

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

Article #991

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

#991

From: hirschv at mindspring dot com Ke...
Date: Mon, 25 May 1998 00:00

20 lines
1205 bytes

Uwe Setje-Eilers <Uwe_Setje-Eilers@t-online.de> wrote:

>with the SAVE TO clause of the SELECT command (local SQL) I can save the
>results of a query into a new table (e.g. "SELECT avg(field1) from
>oldfile SAVE TO newfile"). Instead of saving the data into a new table,
>I would like to assign the result of the query to a memory variable. Is
>this possible? How do I do it?

Leave of the SAVE TO clause, and instead just look at the single
field, single-row table generated, and store that to a memvar.

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Please respond in the newsgroup unless explictly asked otherwise

Technical Details

Message-ID: <35699f67.1871555@forums.borland.com>

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

References: <3569810B.6159@t-online.de>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ab7b419a71db466c
X-Google-Attributes: gidff5a1,public
From: hirschv at mindspring dot com (Ken Mayer [TeamB])
Subject: Re: SELECT command
Date: 1998/05/25
Message-ID: <35699f67.1871555@forums.borland.com>
X-Deja-AN: 356378042
References: <3569810B.6159@t-online.de>
Organization: Golden Stag Productions
Reply-To: hirschv@nospam.mindspring.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message