Calculated Fields

Article View: borland.public.cppbuilder.database.ado

Article #4339

Back to borland.public.cppbuilder.database.ado Previous Next

#4339

From: mikec
Date: Thu, 14 Feb 2002 12:53

12 lines
1372 bytes

Hi everyone,

Wondering if anyone can help me.  I'm doing some work with a database that
someone else as developed.  In one of the fields they use a numeric code to
indicate certain status information.  When I retrieve this information in my
query I want to convert these numeric codes in corresponding message strings
i.e. 99 would equal "Can't open application" etc.  I've got a feeling that
there's an easy way to do this but I can't find it.

Any Help would be excellent.

Thanks Mike C

Technical Details

Message-ID: <3c6bb48d$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,335db53b3a1b75e7,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-02-14 05:10:28 PST
Reply-To: "mikec" <mikec@risc-com.co.uk>
From: "mikec" <mikec@risc-com.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Calculated Fields
Date: Thu, 14 Feb 2002 12:53:57 -0000
Lines: 14
Organization: Risc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 217.23.232.66
Message-ID: <3c6bb48d$1_2@dnews>
X-Trace: dnews 1013691533 217.23.232.66 (14 Feb 2002 04:58:53 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews