OR in SQL Statement

Thread View: comp.lang.pascal.delphi.databases

2 messages

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

2 total messages Started by Petr Hodbo� Mon, 10 Nov 1997 00:00

#150

Author: Petr Hodbo�
Date: Mon, 10 Nov 1997 00:00

19 lines
1086 bytes

Hi folks,
I have found some bug in BDE.
I wrote SQL as this

select var1, var1_min, var1_max
from VARIATION
where var1="1" and (var1_min = "" or var1_max="")

When I wrote statement without 'OR' I get CanModify = True (live result
set.)
When I wrote statement with 'OR' the CanModify was False (read only
result set)
In help was written that I can use AND , OR
I'm using now D1 and BDE 2.5
Does anybody know what I have to do to get Live result set with 'OR' in
statement?
Thank a lot
Petr

Re: OR in SQL Statement

#151

Author: Richard K Carter
Date: Mon, 10 Nov 1997 00:00

9 lines
1107 bytes

You should probably get the free upgrade to BDE 2.52, just in
case it helps; it does have some improved SQL support, and
includes a help file that explains the changes and improvements.
It still won't support all SQL statements that it should, though.
--
============================================================
Rick Carter   carterrk@email.uc.edu   rcarter@tso.cin.ix.net
============================================================

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