Re: Record locking - sligtly off topic

[Mike.Barton@xxxxxxxxxxxx]

The original post was to do (I thought) with a program error in that
the program flagged the record as being deleted (ie setting a flag on
the file) but not actually performing a delete.

To undelete records, there is an undel command from the www.shareware400.com
website (under system operator aids) which actually does this.

Mike


>When a record is deleted it is never really deleted it just has a D in a
>status field and then all programs and reports will ignore a record with  a
>D in the status field.
>
>
>----- Original Message -----
>From: "Dhasaratha Kumar" <DhasarathaK@alfuttaim.co.ae>
>To: <RPG400-L@midrange.com>
>Sent: Tuesday, May 30, 2000 11:19 PM
>Subject: RE: Record locking
>
>.
>> Hi quazy,
>>
>> Can you tell me how to retrieve the deleted record from the data base
>file.
>>
>> Regards
>>
>> D.Dhasaratha Kumar.
>> Analyst Programmer.
>> Al-Futtaim Information Systems,Technologies&Services.
>> P.O.Box no: 152
>> Dubai, U.A.E.
>> Ph: Off: 009714-3027391(Dir).
>>             009714-3970966.
>>     Res: 009714-3593920.
>> e-mail : Dhasarathak@alfuttaim.co.ae.
>>             Dhasarathak@hotmail.com.
>>
>> -----Original Message-----
>> From: Quazy [mailto:quazy@SoftHome.net]
>> Sent: 31 May 2000 00:53
>> To: RPG400-L@midrange.com
>> Subject: Record locking
>>
>>
>> I have a program that when a user deletes a record it just marks the
>record
>> for delete, that way all the data is all still there if we need to get it
>> back.   But if a user decides they did not want to delete the record and
>> recreates it before they exit that portion of the app they cant because
>>the
>> record is still locked.   I have tried using the unlck command and I have
>> tried closing the file and opening it back up again but nothing seems to
>> work.   the lock gets hung up on a chain command.       Am I just doing
>>this
>> wrong or what, any suggestions would be greatly appreciated.
>>
>>
>>
>> Thanks Chris


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---