RE: SQL question

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Dennis,

I'd need to see your entire SELECT statement and have some information about
the rows in the table to know what's causing a single row to be returned,
but here's some things to consider.  I've never seen SQLthing.  Perhaps it
only shows one row at a time and you have to scroll through them.  Is there
a WHERE clause on your SELECT statement?  Are you sure it will return all 10
rows?  If you have Ops Nav installed, try Run SQL Scripts  (right click on
Database) and see if you get the same results.

Regards,
Stan

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Wednesday, 19 September, 2001 11:02 AM
To: 'midrange-l@midrange.com'
Subject: RE: SQL question


Stan,

Commitment was the answer to my question.  Next question is why only one row
is returned when doing a "Select *" from the table when there are 10 rows in
the table?

I've looked at the explanation for commitment & it gets explained about 100
pages further into the book.

Thanks - Dennis.

Dennis Munro