ABL: Close buffer after using FOR EACH

Yahoo Archive
1
Joe,



I had a problem once with some code that appears to be creating record
retention issues. I placed a "RELEASE tablename" statement in my code once
I was done with the data. It seemed to clear up the problem. I didn't go
back and do a bunch of testing on it to "prove" that this worked, but I've
used the RELEASE a number of times when I've got fairly complicated code and
it doesn't seem to hurt.


Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joe Rojas
Sent: Friday, February 04, 2011 10:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ABL: Close buffer after using FOR EACH





Thanks Brian,

I was hoping that the buffer was scope specific. It had always seemed to
be that way but I just wanted to make sure.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Friday, February 04, 2011 10:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ABL: Close buffer after using FOR EACH

You'll only lock the record in question while it is in the record
buffer, and by default Progress puts a SHARE-LOCK on the record while it
is being read (so others can read it), and only an EXCLUSIVE-LOCK when
it is being updated. So you'd only lock the particular row in the
company table for writing when the ASSIGN statement is actually being
executed.

Once the record goes out of scope and leaves the buffer, the locks go
away.

At least that's I how I read the reference guide.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us
about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the company.

-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Friday, February 04, 2011 10:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ABL: Close buffer after using FOR EACH

Hello,

I want to minimize how long I have a record locked when updating a table
in 4GL/ABL.

If I have a simple example like:

For each Company where Company.Company = "COMPNAME":

Assign Company.Number01 = Company.Number01 + 1.

End.

Is the buffer to Company closed as soon as the "End" is executed or do I
need to explicitly close the buffer somehow?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Hello,



I want to minimize how long I have a record locked when updating a table
in 4GL/ABL.



If I have a simple example like:



For each Company where Company.Company = "COMPNAME":

Assign Company.Number01 = Company.Number01 + 1.

End.



Is the buffer to Company closed as soon as the "End" is executed or do I
need to explicitly close the buffer somehow?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
You'll only lock the record in question while it is in the record
buffer, and by default Progress puts a SHARE-LOCK on the record while it
is being read (so others can read it), and only an EXCLUSIVE-LOCK when
it is being updated. So you'd only lock the particular row in the
company table for writing when the ASSIGN statement is actually being
executed.

Once the record goes out of scope and leaves the buffer, the locks go
away.

At least that's I how I read the reference guide.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Friday, February 04, 2011 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ABL: Close buffer after using FOR EACH

Hello,



I want to minimize how long I have a record locked when updating a table
in 4GL/ABL.



If I have a simple example like:



For each Company where Company.Company = "COMPNAME":

Assign Company.Number01 = Company.Number01 + 1.

End.



Is the buffer to Company closed as soon as the "End" is executed or do I
need to explicitly close the buffer somehow?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring


This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Thanks Brian,



I was hoping that the buffer was scope specific. It had always seemed to
be that way but I just wanted to make sure.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, February 04, 2011 10:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ABL: Close buffer after using FOR EACH





You'll only lock the record in question while it is in the record
buffer, and by default Progress puts a SHARE-LOCK on the record while it
is being read (so others can read it), and only an EXCLUSIVE-LOCK when
it is being updated. So you'd only lock the particular row in the
company table for writing when the ASSIGN statement is actually being
executed.

Once the record goes out of scope and leaves the buffer, the locks go
away.

At least that's I how I read the reference guide.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Friday, February 04, 2011 10:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ABL: Close buffer after using FOR EACH

Hello,

I want to minimize how long I have a record locked when updating a table
in 4GL/ABL.

If I have a simple example like:

For each Company where Company.Company = "COMPNAME":

Assign Company.Number01 = Company.Number01 + 1.

End.

Is the buffer to Company closed as soon as the "End" is executed or do I
need to explicitly close the buffer somehow?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links




[Non-text portions of this message have been removed]
5
I'm not a Progress/OpenEdge expert, but I read through the docs on
'FOR' and the record selection info and that's how it reads to me.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Friday, February 04, 2011 10:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ABL: Close buffer after using FOR EACH

Thanks Brian,



I was hoping that the buffer was scope specific. It had always seemed to
be that way but I just wanted to make sure.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, February 04, 2011 10:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ABL: Close buffer after using FOR EACH





You'll only lock the record in question while it is in the record
buffer, and by default Progress puts a SHARE-LOCK on the record while it
is being read (so others can read it), and only an EXCLUSIVE-LOCK when
it is being updated. So you'd only lock the particular row in the
company table for writing when the ASSIGN statement is actually being
executed.

Once the record goes out of scope and leaves the buffer, the locks go
away.

At least that's I how I read the reference guide.












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring


This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.



-----Original Message-----

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Friday, February 04, 2011 10:00 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ABL: Close buffer after using FOR EACH

Hello,

I want to minimize how long I have a record locked when updating a table
in 4GL/ABL.

If I have a simple example like:

For each Company where Company.Company = "COMPNAME":

Assign Company.Number01 = Company.Number01 + 1.

End.

Is the buffer to Company closed as soon as the "End" is executed or do I
need to explicitly close the buffer somehow?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and
beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links