OR in SQL Statement

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

Article #150

Back to comp.lang.pascal.delphi.databases Previous Next

#150

From: 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

Technical Details

Message-ID: <346739F3.B25C3E74@mendelu.cz>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,172a1c2d98ba45c2,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,172a1c2d98ba45c2,start
X-Google-Attributes: gid10de66,public
From: "Petr Hodbo�" <hodbod@mendelu.cz>
Subject: OR in SQL Statement
Date: 1997/11/10
Message-ID: <346739F3.B25C3E74@mendelu.cz>
X-Deja-AN: 288349097
Sender: news@news.muni.cz (News Admin)
X-Nntp-Posting-Host: fence.vszbr.cz
Organization: Masaryk University,Brno
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers