Re: LookupSQL

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

Article #1356

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

#1356

From: Tom Arnold
Date: Tue, 10 Feb 1998 00:00

18 lines
1173 bytes

I got it to work finally.  It was a database problem.  But there was
another thing.  The OLH example shows this syntax with the AS clause:

     "select last, last || ', ' || first as fullname from name"

That wouldn't work so I tried:

     "select last, last || ', ' || first from name"

Which worked fine on a test with a Query directly on the form, or using
a Query in a DMD.  However If I use a Database, it doesn't work.  I'll
post this elsewhere.
--
     Tom

Romain Strieff [TeamB] wrote:
> Can you get it to work from the command window?

Technical Details

Message-ID: <34E0C57B.376B@inna.net>

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

References:

<34DE42C7.B79@inna.net> <MPG.f48fe504feff7ac98a686@forums.borland.com> <34DFC2A6.4BA8@inna.net> <MPG.f4a2fa9819ab61598a69c@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c3e29b88ebef55
X-Google-Attributes: gidff5a1,public
From: Tom Arnold <tarnold@inna.net>
Subject: Re: LookupSQL
Date: 1998/02/10
Message-ID: <34E0C57B.376B@inna.net>
X-Deja-AN: 323864678
Content-Transfer-Encoding: 7bit
References: <34DE42C7.B79@inna.net> <MPG.f48fe504feff7ac98a686@forums.borland.com> <34DFC2A6.4BA8@inna.net> <MPG.f4a2fa9819ab61598a69c@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Microaid
Mime-Version: 1.0
Reply-To: tarnold@inna.net
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message