RE: SQL question

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

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

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

-----Original Message-----
From: MCPARTLAND, Stan [mailto:stanley.mcpartland@bently.com]
Sent: Wednesday, September 19, 2001 10:07 AM
To: 'midrange-l@midrange.com'
Subject: RE: SQL question

Dennis,

It sounds like your changes are being rolled back when you exit SQLThing.
COMMIT your changes before you exit.

Regards,
Stan

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Wednesday, 19 September, 2001 7:59 AM
To: 'RPG400-L@midrange.com'
Subject: SQL question

<snip>

the tables created are there for
the session & as soon as I close my session down (using SQLThing) the tables
& any changes I made disappear.  When I run the same exercises through
STRSQL, all is fine.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.