Re: Does paradox sql support "select iif(area > 100, 0, area) as newarea from tabarea"?

Article View: borland.public.cppbuilder.database.multi-tier

Article #1132

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1132

From: james
Date: Tue, 09 May 2000 00:00

25 lines
1528 bytes

I know CASE statement in sql server or oracle , but I don't know if it can
use in local sql(in paradox),can you give me
some sample.

Thank you!

Abaco Informatica <abasoft@satlink.com> wrote in message
news:8f6s5m$sbi4@bornews.borland.com...
> I am not sure whether the IIF is supported, but if you are having trouble
> with that you can try the CASE statement instead.
>
> Sergio Sansosti
> �baco inform�tica
> Argentina
>
> james escribi?en mensaje <39162eaf@dnews>...
> >1.Does paradox sql support "select iif(area > 100, 0, area) as newarea
from
> >tabarea"?
> >2.Can I do checkbox in dbgrid?
> >
> >
> >
>
>

Technical Details

Message-ID: <391770c0@dnews>

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

References: <39162eaf@dnews> <8f6s5m$sbi4@bornews.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fcd2b,4de107ab753c1cf6
X-Google-Attributes: gidfcd2b,public
X-Google-Thread: f5c5c,4de107ab753c1cf6
X-Google-Attributes: gidf5c5c,public
X-Google-Thread: fc5f9,4de107ab753c1cf6
X-Google-Attributes: gidfc5f9,public
From: "james" <mysoft0684@sina.com>
Subject: Re: Does paradox sql support "select iif(area > 100, 0, area) as newarea from tabarea"?
Date: 2000/05/09
Message-ID: <391770c0@dnews>
X-Deja-AN: 620924130
References: <39162eaf@dnews> <8f6s5m$sbi4@bornews.borland.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Trace: 8 May 2000 18:58:24 -0800, 61.129.17.99
X-MSMail-Priority: Normal
Reply-To: "james" <mysoft0684@sina.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier,borland.public.cppbuilder.database.sqlservers,borland.public.cppbuilder.vcl.components.using

Reply to Parent Message