Re: Help with SQL and memory variables.

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

Article #788

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

#788

From: Paul Franks
Date: Mon, 20 Jul 1998 00:00

19 lines
967 bytes

In article <35B1A9AF.8788721@access.mountain.net>, 
cohe106w@access.mountain.net says...
> I simply
> don't know how to reference the memory variable in the sql statement or
> in
> the visual sql tools.
> 
> 

The variable should simply need a leading colon to designate it as a 
memvar and not a field,

  myvar="Craig"
  select * from mytable d where d.firstname=:myvar

I don't know how the visual designer handles this but you should be able 
to reverse engineer it from the code above.
-- 
Paul Franks (TeamB)

Technical Details

Message-ID: <MPG.101c8f78cd2ab1d98985c@forums.inprise.com>

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

References: <35B1A9AF.8788721@access.mountain.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,d29952a1b56f8d15
X-Google-Attributes: gidff5a1,public
From: supportinfo@borland.com (Paul Franks)
Subject: Re: Help with SQL and memory variables.
Date: 1998/07/20
Message-ID: <MPG.101c8f78cd2ab1d98985c@forums.inprise.com>
X-Deja-AN: 373135050
References: <35B1A9AF.8788721@access.mountain.net>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message