Re: Select Character + Numeric

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

Article #685

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

#685

From: Brian Benson
Date: Mon, 10 Aug 1998 00:00

16 lines
1177 bytes

Geoff S. Wass wrote in message <35CE9980.BBCB5D1E@ibm.net>...
>Brian,
>
>If that is the case, I would tackle it from another angle. Create a
>calculated field for your table that is equal to your char+num
>requirement. Then, SELECT yourCalcField FROM yourTable...
>
Thankyou Geoff,
The application is a bit complicated because the 'Select' statement is for a
'lookupsql' property. I have avoided the problem by selecting both fields
and combining them in a 'beforegetvalue' function, but the message from
Steve Koterski offers another, probably better, way so I will probably  try
that also.

Brian

Technical Details

Message-ID: <6qniue$s1s16@forums.borland.com>

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

References:

<6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> <6qkgsd$ofg7@forums.borland.com> <35CE9980.BBCB5D1E@ibm.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e0ca2689a5358a7a
X-Google-Attributes: gidff5a1,public
From: "Brian Benson" <brian.benson@BTInternet.com>
Subject: Re: Select Character + Numeric
Date: 1998/08/10
Message-ID: <6qniue$s1s16@forums.borland.com>
X-Deja-AN: 379813701
References: <6qhdmj$k8r8@forums.borland.com> <35CC45CE.8F82A5C8@ibm.net> <6qkgsd$ofg7@forums.borland.com> <35CE9980.BBCB5D1E@ibm.net>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Eureko Ltd
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message