🚀 go-pugleaf

>The choice of which records to include in or exclude from the result
set is
>determined by conditions in the WHERE clause. The fields in the
SELECT
>clause of the statement should never affect this, regardless of their
order
>of appearance or whether they appear at all in the SELECT clause.
>
>Post your actual SQL statement.
>
>/////////////////////////////////////////////////////////////////////
/////
>Steve Koterski                      "Knowledge comes, but wisdom
lingers."
>Technical Publications                -- Alfred, Lord Tennyson
(1809-1914)
>INPRISE Corporation
>http://www.inprise.com/delphi
Steve,

Below is one form of the query.  If you change the order in which you
call the fields, the query results seem to change.  I am not a expert
in this and am just trying to understand why and how it works so I can
use it more effectively.
This particular query in on a form open event so I can datalink it to
a grid to be able to view the results.  BTW do you know of a more
efficient way to view the results?  I have tried many different forms
of this query and get results that are not what I expect in many
instances.

For instance if it reads:
where (headfn = '&hdfn')
and (headln = '&hdln')
and etc.

The query comes up blank.  Why?


Jason Ortner         jortnerxxppmm@onramp113.org
----------------------------------------------------------------------
-----------------------------------


form.fe = new query()
   form.fe.sql = "select
headfn,headln,heelfn,heelln,dateofrope,drawnum;
   from rope1.dbf rope1;
where (headfn = '&hdfn');
     AND (headln = '&hdln');
     OR (heelfn = '&hefn');
     and (heelln = '&heln');
     OR (headln = '&heln')"