RE: SQL - File staying locked.

["Leland, David" <dleland@xxxxxxxxxx>]

I would have a tendency to agree with Pluta on this - for one record chains
I don't use SQL.  I would do an OPEN, CHAIN to the file and then a CLOSE.
This would allow you to leave LR off when exiting the program (for faster
repeat calling) and still prevent the file lock problem.  Same effect as
what you are trying to accomplish with SQL.

Dave

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Friday, April 25, 2003 9:26 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL - File staying locked.


I thought of that David, but if I am doing a one record read, then why use 
a cursor?  For example if I have a file ITEMMASTER with a primary key 
constraint on ITEMNUM why would I use a cursor to do the following?

select price into :listprice from itemmaster
where itemnumber=:itemnum

I can just see Pluta, "I wouldn't use a cursor either, I'd use a 
traditional rpg chain."   :-)