🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

LookupSQL

#1350
From: Tom Arnold
Date: Sun, 08 Feb 1998 00:00
14 lines
928 bytes
Can anyone see why my LookUpSQL statement doesn't work?  Can't seem to
get a calculated field to work even though seem to be following the OLH
exactly.

     SELECT LAST, FIRST FROM NAME                   <== This works, but
     SELECT LAST, FIRST || LAST AS FULLNAME FROM NAME     <== This
Doesn't

When I say works, I get no errors from the FD, but when the code is run
it does not show in a ComboBox.  No other changes made in form.
-- 
   Tom 
   Bena, VA
Technical Details
Message-ID: <34DE42C7.B79@inna.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5c3e29b88ebef55,start
X-Google-Attributes: gidff5a1,public
From: Tom Arnold <tarnold@inna.net>
Subject: LookupSQL
Date: 1998/02/08
Message-ID: <34DE42C7.B79@inna.net>
X-Deja-AN: 323261413
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: Microaid
Mime-Version: 1.0
Reply-To: tarnold@inna.net
Newsgroups: borland.public.vdbase.data.sql