Re: SELECT command

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

Article #999

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

#999

From: Keith G. Chuvala (TeamB)
Date: Wed, 27 May 1998 00:00

11 lines
996 bytes

> 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?

In addition to Ken's answer, if your answer set contains multiple fields and
you want all of them stored to memory variables, issue the command STORE
AUTOMEM after your SELECT statement.  That saves the values of all the fields
in the current record's view to like-named memory variables.  Works great!

kgc

Technical Details

Message-ID: <356C3F7B.2FE3CC6D@DELETE_THIS.hit.net>

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: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: SELECT command
Date: 1998/05/27
Message-ID: <356C3F7B.2FE3CC6D@DELETE_THIS.hit.net>
X-Deja-AN: 357017311
Content-Transfer-Encoding: 7bit
References: <3569810B.6159@t-online.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message