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

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by james Mon, 08 May 2000 00:00

#1127

Author: james
Date: Mon, 08 May 2000 00:00

3 lines
960 bytes

1.Does paradox sql support "select iif(area > 100, 0, area) as newarea from
tabarea"?
2.Can I do checkbox in dbgrid?

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

#1128

Author: Abaco Informatica
Date: Mon, 08 May 2000 00:00

14 lines
1159 bytes

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?
>
>
>

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

#1132

Author: 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?
> >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads