PDA

View Full Version : TranLock.Pkg Version 2



Peter A Donovan
15-Mar-2006, 04:04 AM
Hi,
I have recently discovered that using TranLock.Pkg with manual saverecords
that caused a lockup problem otherwise is inappropriate, and in this case,
TranLock.Pkg should not be used to bandaid your problem.

What I discovered is that alias file declarations, when properly done, and
include statements to "USE" the DD instead of "OPEN"ing a file will solve
your lockup problems so you don't need this package, and should not use it
for that purpose.

However, there are times when TranLock.Pkg can be of value, especially with
multiple transactions in a transaction block.

The only value this package has is to optimize the number of files locked
during a transaction.

Here then, is the updated TranLock.Pkg which shows you by example how to
overcome your lockup problems and an example of good use of TranLock.Pkg.

Regards,
Peter Donovan
Sonata Software: www.SonataSoftware.US
Northeast DataFlex Consortium Member: www.NEDataFlex.Com

Mk@p3rfect
20-Mar-2006, 09:03 AM
Hi Peter,
I use your pkg extensively and have always found it very reliable. I'm not
sure what you mean by inappropriate. Is this just a question of rigidly
sticking to DAW's guidelines or are there other issues.

While I'm here, and with regard to the usage of the package, I think it
might be an idea to give a warning about inadvertantly nesting the
ChangeAllFileModes procedure. I recently did this and I really screwed
things up big time.

Best Regards
Mk

"Peter A Donovan" <SonataSoftwareUS@Yahoo.Com> wrote in message
news:xLcXh9ASGHA.3232@dacmail.dataaccess.com...
> Hi,
> I have recently discovered that using TranLock.Pkg with manual saverecords
> that caused a lockup problem otherwise is inappropriate, and in this case,
> TranLock.Pkg should not be used to bandaid your problem.
>
> What I discovered is that alias file declarations, when properly done, and
> include statements to "USE" the DD instead of "OPEN"ing a file will solve
> your lockup problems so you don't need this package, and should not use it
> for that purpose.
>
> However, there are times when TranLock.Pkg can be of value, especially
> with multiple transactions in a transaction block.
>
> The only value this package has is to optimize the number of files locked
> during a transaction.
>
> Here then, is the updated TranLock.Pkg which shows you by example how to
> overcome your lockup problems and an example of good use of TranLock.Pkg.
>
> Regards,
> Peter Donovan
> Sonata Software: www.SonataSoftware.US
> Northeast DataFlex Consortium Member: www.NEDataFlex.Com
>
>

Peter A Donovan
26-Mar-2006, 01:44 AM
Hi MK,
See notes inside this package.
I have determined that lockups (if that's the reason you use it) on rereads
can be eliminated completely by following the steps in the package.

If you are not getting lockups, but are using manual saverecords, you should
really be doing DDO saves.

If you are using the package solely due to lockups, then the usage of this
package is inappropriate even though it solves the problem.

The only good usage of this package is to optimize the locking of a
transaction so only certain files are locked.

I once thought that alias files when declared properly still caused a
lockup, but now I know that isn't true. See package for instructions!

PS: I am just about to use it myself, but not to avoid a lockup problem: I
have to save to the trial balance and delete entries so I want to bind them
in a single rollback transaction and only lock 3 files.

Regards,
Peter
Sonata Software: www.SonataSoftware.US
Northeast DataFlex Consortium Member: www.NEDataFlex.Com
"Mk" <Mk@p3rfect.net> wrote in message
news:pmeCEcCTGHA.3232@dacmail.dataaccess.com...
> Hi Peter,
> I use your pkg extensively and have always found it very reliable. I'm not
> sure what you mean by inappropriate. Is this just a question of rigidly
> sticking to DAW's guidelines or are there other issues.
>
> While I'm here, and with regard to the usage of the package, I think it
> might be an idea to give a warning about inadvertantly nesting the
> ChangeAllFileModes procedure. I recently did this and I really screwed
> things up big time.
>
> Best Regards
> Mk
>
> "Peter A Donovan" <SonataSoftwareUS@Yahoo.Com> wrote in message
> news:xLcXh9ASGHA.3232@dacmail.dataaccess.com...
>> Hi,
>> I have recently discovered that using TranLock.Pkg with manual
>> saverecords that caused a lockup problem otherwise is inappropriate, and
>> in this case, TranLock.Pkg should not be used to bandaid your problem.
>>
>> What I discovered is that alias file declarations, when properly done,
>> and include statements to "USE" the DD instead of "OPEN"ing a file will
>> solve your lockup problems so you don't need this package, and should not
>> use it for that purpose.
>>
>> However, there are times when TranLock.Pkg can be of value, especially
>> with multiple transactions in a transaction block.
>>
>> The only value this package has is to optimize the number of files locked
>> during a transaction.
>>
>> Here then, is the updated TranLock.Pkg which shows you by example how to
>> overcome your lockup problems and an example of good use of TranLock.Pkg.
>>
>> Regards,
>> Peter Donovan
>> Sonata Software: www.SonataSoftware.US
>> Northeast DataFlex Consortium Member: www.NEDataFlex.Com
>>
>>
>
>