sql quirks

Article View: borland.public.vdbase.data.sql

Article #954

Back to borland.public.vdbase.data.sql Previous Next

#954

From: Jason Ortner
Date: Fri, 05 Jun 1998 00:00

14 lines
1266 bytes

I have a question regarding the way sql retrieves data.   I have a
query I am using, that retrieves data, sometimes.  Does the order in
which you have the select stmt. fields have anything to do with the
way in which the data is retrieved?  If I ask for info.,using the
"like" clause on one field where there is no data that matches, but I
ask for other fields, in the same query,where there is data that
matches it appears that if the first field doesn't match, the whole
query is blank.  If anyone wants to see a copy of the query I will be
glad to post it.  This makes no sense to me and the "Learn sql" disk
doesn't seem to really cover the problem.  Any ideas.

--
Jason Ortner         jortnerxxppmm@onramp113.org

Technical Details

Message-ID: <6l9obd$t6j4@forums.borland.com>

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: ff5a1,7e01f50b41e45756,start
X-Google-Attributes: gidff5a1,public
From: "Jason Ortner" <jortner@onramp113.org>
Subject: sql quirks
Date: 1998/06/05
Message-ID: <6l9obd$t6j4@forums.borland.com>
X-Deja-AN: 359953488
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql