Lock table overflow

system · August 1, 2001, 7:25pm

At 03:14 PM 8/1/2001 , you wrote:

>I forgot something. AppBuilder, Results and Procedure Editor are not
>the only tools necessary to compile and run a program. Vantage
>itself can do both!

Yup! Actually I think it's Progress that deserves the credit, but it will
work. You can create 4GL code with the Progress Client or Procedure
Editor, or your favorite text editor and save it as a .P file. Vantage can
run it that way (compile on the fly, I guess?) Or from the Procedure
Editor, you can compile it into a .R file, which might start and run a
little quicker.

You can do just about everything, except run or compile code that writes to
the DB. It should be adequate for reports and most other stuff a Vantage
site would want to develop. You can put together graphic forms, but
without the App Builder component of ProVision, you have to lay them all
out manually in excruciating detail.

Had we known the basic Progress product had that much, we probably wouldn't
have dropped the $$ on ProVison. Come to think of it, the sales guy hit us
up for extra Report Builder seats, and didn't mention ProVision included
one of those too. Ahh well... drop in the bucket at this point.

-Wayne Cox

system · July 31, 2001, 4:07pm

To all,
I have written a small progress program that generates a lock table
overflow error (error # 915 I think), and then it bombs out. Here is
the program:

define variable count as integer.
set count = 0.

for each orderrel where orderrel.make = yes:
update orderrel
set orderrel.make = no.
set count = count + 1.
end.
Bell.
message "Done. Fixed " count " flags." view-as alert-box.

I don't remember where to set the -l, so I can't tell you what it is
set to right now. Is this all I need to change, or have I made a
mistake in my programming? The syntax check says it is ok...

And please don't ask why I want to flip all these flags, we are
working through some major procedural issues with Vantage, and this
is only a temporary (I hope!!) fix.

Thanks for your help!!!

system · July 31, 2001, 4:17pm

What version are you on?

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Lock table overflow

To all,
I have written a small progress program that generates a lock table
overflow error (error # 915 I think), and then it bombs out. Here is
the program:

define variable count as integer.
set count = 0.

for each orderrel where orderrel.make = yes:
update orderrel
set orderrel.make = no.
set count = count + 1.
end.
Bell.
message "Done. Fixed " count " flags." view-as alert-box.

I don't remember where to set the -l, so I can't tell you what it is
set to right now. Is this all I need to change, or have I made a
mistake in my programming? The syntax check says it is ok...

And please don't ask why I want to flip all these flags, we are
working through some major procedural issues with Vantage, and this
is only a temporary (I hope!!) fix.

Thanks for your help!!!

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 4:20pm

We are on Vantage 4.0.904 Progress 9.0B.

Thanks Mark!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> What version are you on?
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:07 PM
> To: vantage@y...
> Subject: [Vantage] Lock table overflow
>
>
> To all,
> I have written a small progress program that generates a lock table
> overflow error (error # 915 I think), and then it bombs out. Here is
> the program:
>
> define variable count as integer.
> set count = 0.
>
> for each orderrel where orderrel.make = yes:
> update orderrel
> set orderrel.make = no.
> set count = count + 1.
> end.
> Bell.
> message "Done. Fixed " count " flags." view-as alert-box.
>
> I don't remember where to set the -l, so I can't tell you what it is
> set to right now. Is this all I need to change, or have I made a
> mistake in my programming? The syntax check says it is ok...
>
> And please don't ask why I want to flip all these flags, we are
> working through some major procedural issues with Vantage, and this
> is only a temporary (I hope!!) fix.
>
> Thanks for your help!!!
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

system · July 31, 2001, 4:26pm

Is there a reason to use the update and set? I would normally write this as
follows:

define variable count as integer.
assign count = 0.

for each orderrel where orderrel.make = yes:
assign orderrel.make = no.
assign count = count + 1.
end.

message "Done. Fixed " count " flags." view-as alert-box.

Or am I missing something? I don't know if this has anything to do with your
problem or not. Just the first thing I saw when I looked at it.

Mark Kohring

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

We are on Vantage 4.0.904 Progress 9.0B.

Thanks Mark!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> What version are you on?
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:07 PM
> To: vantage@y...
> Subject: [Vantage] Lock table overflow
>
>
> To all,
> I have written a small progress program that generates a lock table
> overflow error (error # 915 I think), and then it bombs out. Here is
> the program:
>
> define variable count as integer.
> set count = 0.
>
> for each orderrel where orderrel.make = yes:
> update orderrel
> set orderrel.make = no.
> set count = count + 1.
> end.
> Bell.
> message "Done. Fixed " count " flags." view-as alert-box.
>
> I don't remember where to set the -l, so I can't tell you what it is
> set to right now. Is this all I need to change, or have I made a
> mistake in my programming? The syntax check says it is ok...
>
> And please don't ask why I want to flip all these flags, we are
> working through some major procedural issues with Vantage, and this
> is only a temporary (I hope!!) fix.
>
> Thanks for your help!!!
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 4:44pm

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

system · July 31, 2001, 4:54pm

I was talking to my boss about this, he says update writes to the screen
buffer. Are you sure that you want to bypass the write trigger? If so there
is a command that will bypass a trigger. Can't think of it off the top of my
head though. I am looking for it right now. If anyone else knows it let me
know.

Mark Kohring

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 4:58pm

Found it. It is OVERRIDE. Check out the keyword help and it will tell you
how to use it to override the trigger.

Mark

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:03pm

At 04:53 PM 7/31/2001 , you wrote:

>I was talking to my boss about this, he says update writes to the screen
>buffer. Are you sure that you want to bypass the write trigger? If so there
>is a command that will bypass a trigger. Can't think of it off the top of my
>head though. I am looking for it right now. If anyone else knows it let me

Like Mark said, it's probably best not to bypass them. But this will do it:
on write of OrderRel override do: end.

Putting V:\Vantage in the propath should let the triggers work.

-Wayne

system · July 31, 2001, 5:04pm

First of all, this program is trying to write to the database, and THE
PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE TO THE
DATABASE, according to Doug Williams, director of development. In order to
write to the database, you have to purchase provision, and you risk
corrupting the database and incurring billable support.... etc...

to quote Doug Himself
"Just a comment on the 4GL coding topic: With a Progress Query license (the
license normally shipped with Vantage) you cannot compile programs that
update the database. Since you cannot write/run any programs that change
any data you don't have to worry about damaging anything and it being
billable support, etc."

anyway,

ASSIGN sets the temporary memory value value, and UPDATE transfers the value
from memory to the record or screen buffer.

SET does both, assigns the temporary memory value, and updates the screen or
record buffer.

I think the lock table overflow error is due to the fact that you are trying
to write to the database, or that the for-each statement is locking more
records than allowed. You would fix this by using NO-LOCK in your FOR EACH
STATEMENT. Of course, NO-LOCK would prevent you from writing to the DB, so
combine that with the fact that a Progress Query License doesn't allow you
to write to the DB, and you run into some definite feasibility issues.

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:10pm

take that back. NO-LOCK would mean that while you are editing the record
you are not locking others out. It is standard procedure to lock a record
before editing it. If you use a no-lock statement, and make sure you have a
query license, make sure NO ONE ELSE IS IN VANTAGE, and have a REALLY GOOD
BACKUP, you may just be in business.

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:05 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Lock table overflow

First of all, this program is trying to write to the database, and THE
PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE TO THE
DATABASE, according to Doug Williams, director of development. In order to
write to the database, you have to purchase provision, and you risk
corrupting the database and incurring billable support.... etc...

to quote Doug Himself
"Just a comment on the 4GL coding topic: With a Progress Query license (the
license normally shipped with Vantage) you cannot compile programs that
update the database. Since you cannot write/run any programs that change
any data you don't have to worry about damaging anything and it being
billable support, etc."

anyway,

ASSIGN sets the temporary memory value value, and UPDATE transfers the value
from memory to the record or screen buffer.

SET does both, assigns the temporary memory value, and updates the screen or
record buffer.

I think the lock table overflow error is due to the fact that you are trying
to write to the database, or that the for-each statement is locking more
records than allowed. You would fix this by using NO-LOCK in your FOR EACH
STATEMENT. Of course, NO-LOCK would prevent you from writing to the DB, so
combine that with the fact that a Progress Query License doesn't allow you
to write to the DB, and you run into some definite feasibility issues.

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:25pm

I am pretty sure that when you write to the database using a shared-lock it
upgrades it to an exclusive-lock while writing and then sets it back to
shared. I don't think you can write to it at all using no-lock, but if you
can it will probably have to go thru the same upgrade to exclusive for the
actual write which would kill the reason for using no-lock in the first
place. I might be wrong, but if you've got time to kill check it out.

Mark

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

take that back. NO-LOCK would mean that while you are editing the record
you are not locking others out. It is standard procedure to lock a record
before editing it. If you use a no-lock statement, and make sure you have a
query license, make sure NO ONE ELSE IS IN VANTAGE, and have a REALLY GOOD
BACKUP, you may just be in business.

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:05 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Lock table overflow

First of all, this program is trying to write to the database, and THE
PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE TO THE
DATABASE, according to Doug Williams, director of development. In order to
write to the database, you have to purchase provision, and you risk
corrupting the database and incurring billable support.... etc...

to quote Doug Himself
"Just a comment on the 4GL coding topic: With a Progress Query license (the
license normally shipped with Vantage) you cannot compile programs that
update the database. Since you cannot write/run any programs that change
any data you don't have to worry about damaging anything and it being
billable support, etc."

anyway,

ASSIGN sets the temporary memory value value, and UPDATE transfers the value
from memory to the record or screen buffer.

SET does both, assigns the temporary memory value, and updates the screen or
record buffer.

I think the lock table overflow error is due to the fact that you are trying
to write to the database, or that the for-each statement is locking more
records than allowed. You would fix this by using NO-LOCK in your FOR EACH
STATEMENT. Of course, NO-LOCK would prevent you from writing to the DB, so
combine that with the fact that a Progress Query License doesn't allow you
to write to the DB, and you run into some definite feasibility issues.

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:31pm

I would check it out, but we don't have a write license, and don't want or
need a write license at this point.

Your probably right about the locks, may want to see if no-lock eliminates
the lock table overflow nonetheless. I'm not sure, but the program may be
trying to lock all the records at once.

Are you using provision, or a standard as-shipped progress license. Has
anyone written to the Vantage DB using the standard as-shipped license?

~thad

-----Original Message-----
From: Mark Kohring [mailto:mkohring@...]
Sent: Tuesday, July 31, 2001 4:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

I am pretty sure that when you write to the database using a shared-lock it
upgrades it to an exclusive-lock while writing and then sets it back to
shared. I don't think you can write to it at all using no-lock, but if you
can it will probably have to go thru the same upgrade to exclusive for the
actual write which would kill the reason for using no-lock in the first
place. I might be wrong, but if you've got time to kill check it out.

Mark

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

take that back. NO-LOCK would mean that while you are editing the record
you are not locking others out. It is standard procedure to lock a record
before editing it. If you use a no-lock statement, and make sure you have a
query license, make sure NO ONE ELSE IS IN VANTAGE, and have a REALLY GOOD
BACKUP, you may just be in business.

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:05 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Lock table overflow

First of all, this program is trying to write to the database, and THE
PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE TO THE
DATABASE, according to Doug Williams, director of development. In order to
write to the database, you have to purchase provision, and you risk
corrupting the database and incurring billable support.... etc...

to quote Doug Himself
"Just a comment on the 4GL coding topic: With a Progress Query license (the
license normally shipped with Vantage) you cannot compile programs that
update the database. Since you cannot write/run any programs that change
any data you don't have to worry about damaging anything and it being
billable support, etc."

anyway,

ASSIGN sets the temporary memory value value, and UPDATE transfers the value
from memory to the record or screen buffer.

SET does both, assigns the temporary memory value, and updates the screen or
record buffer.

I think the lock table overflow error is due to the fact that you are trying
to write to the database, or that the for-each statement is locking more
records than allowed. You would fix this by using NO-LOCK in your FOR EACH
STATEMENT. Of course, NO-LOCK would prevent you from writing to the DB, so
combine that with the fact that a Progress Query License doesn't allow you
to write to the DB, and you run into some definite feasibility issues.

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:39pm

Yes we have provision, and the source code. I do some small custom mods for
our company. In fact I've done a couple not so small ones too!

Mark

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:32 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

I would check it out, but we don't have a write license, and don't want or
need a write license at this point.

Your probably right about the locks, may want to see if no-lock eliminates
the lock table overflow nonetheless. I'm not sure, but the program may be
trying to lock all the records at once.

Are you using provision, or a standard as-shipped progress license. Has
anyone written to the Vantage DB using the standard as-shipped license?

~thad

-----Original Message-----
From: Mark Kohring [mailto:mkohring@...]
Sent: Tuesday, July 31, 2001 4:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

I am pretty sure that when you write to the database using a shared-lock it
upgrades it to an exclusive-lock while writing and then sets it back to
shared. I don't think you can write to it at all using no-lock, but if you
can it will probably have to go thru the same upgrade to exclusive for the
actual write which would kill the reason for using no-lock in the first
place. I might be wrong, but if you've got time to kill check it out.

Mark

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Lock table overflow

take that back. NO-LOCK would mean that while you are editing the record
you are not locking others out. It is standard procedure to lock a record
before editing it. If you use a no-lock statement, and make sure you have a
query license, make sure NO ONE ELSE IS IN VANTAGE, and have a REALLY GOOD
BACKUP, you may just be in business.

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Tuesday, July 31, 2001 4:05 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Re: Lock table overflow

First of all, this program is trying to write to the database, and THE
PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE TO THE
DATABASE, according to Doug Williams, director of development. In order to
write to the database, you have to purchase provision, and you risk
corrupting the database and incurring billable support.... etc...

to quote Doug Himself
"Just a comment on the 4GL coding topic: With a Progress Query license (the
license normally shipped with Vantage) you cannot compile programs that
update the database. Since you cannot write/run any programs that change
any data you don't have to worry about damaging anything and it being
billable support, etc."

anyway,

ASSIGN sets the temporary memory value value, and UPDATE transfers the value
from memory to the record or screen buffer.

SET does both, assigns the temporary memory value, and updates the screen or
record buffer.

I think the lock table overflow error is due to the fact that you are trying
to write to the database, or that the for-each statement is locking more
records than allowed. You would fix this by using NO-LOCK in your FOR EACH
STATEMENT. Of course, NO-LOCK would prevent you from writing to the DB, so
combine that with the fact that a Progress Query License doesn't allow you
to write to the DB, and you run into some definite feasibility issues.

-----Original Message-----
From: acretors@... [mailto:acretors@...]
Sent: Tuesday, July 31, 2001 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Mark,
Either one will work I guess. Does the assign function use memory
differently than the update - set funcition? I gave it a shot as you
indicated below, and I got a "cannot find write.p" error. How do you
get around the write trigger?

Thanks for your input!

--- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> Is there a reason to use the update and set? I would normally write
this as
> follows:
>
> define variable count as integer.
> assign count = 0.
>
> for each orderrel where orderrel.make = yes:
> assign orderrel.make = no.
> assign count = count + 1.
> end.
>
> message "Done. Fixed " count " flags." view-as alert-box.
>
>
>
> Or am I missing something? I don't know if this has anything to do
with your
> problem or not. Just the first thing I saw when I looked at it.
>
> Mark Kohring
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:20 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> We are on Vantage 4.0.904 Progress 9.0B.
>
> Thanks Mark!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > What version are you on?
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:07 PM
> > To: vantage@y...
> > Subject: [Vantage] Lock table overflow
> >
> >
> > To all,
> > I have written a small progress program that generates a lock
table
> > overflow error (error # 915 I think), and then it bombs out. Here
is
> > the program:
> >
> > define variable count as integer.
> > set count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > update orderrel
> > set orderrel.make = no.
> > set count = count + 1.
> > end.
> > Bell.
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> > I don't remember where to set the -l, so I can't tell you what it
is
> > set to right now. Is this all I need to change, or have I made a
> > mistake in my programming? The syntax check says it is ok...
> >
> > And please don't ask why I want to flip all these flags, we are
> > working through some major procedural issues with Vantage, and
this
> > is only a temporary (I hope!!) fix.
> >
> > Thanks for your help!!!
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 5:46pm

Been trying to catch up on this thread ..

Re the license issue. It's my understanding that what comes with
'basic' Vantage does not provide functionally to compile code,
therefore it's not possible to create such.

It's a question of licensing ability to create code, not licensing
the right to modify your DB.

The reverse would mean no third party developer could legally modify
the DB without the client owning Provision.

Lonnie

--- In vantage@y..., Thad Jacobs <tjacobs@k...> wrote:
> I would check it out, but we don't have a write license, and don't
want or
> need a write license at this point.
>
> Your probably right about the locks, may want to see if no-lock
eliminates
> the lock table overflow nonetheless. I'm not sure, but the program
may be
> trying to lock all the records at once.
>
> Are you using provision, or a standard as-shipped progress license.
Has
> anyone written to the Vantage DB using the standard as-shipped
license?
>
> ~thad
>
>
> -----Original Message-----
> From: Mark Kohring [mailto:mkohring@d...]
> Sent: Tuesday, July 31, 2001 4:25 PM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> I am pretty sure that when you write to the database using a
shared-lock it
> upgrades it to an exclusive-lock while writing and then sets it
back to
> shared. I don't think you can write to it at all using no-lock, but
if you
> can it will probably have to go thru the same upgrade to exclusive
for the
> actual write which would kill the reason for using no-lock in the
first
> place. I might be wrong, but if you've got time to kill check it
out.
>
> Mark
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@k...]
> Sent: Tuesday, July 31, 2001 4:11 PM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> take that back. NO-LOCK would mean that while you are editing the
record
> you are not locking others out. It is standard procedure to lock a
record
> before editing it. If you use a no-lock statement, and make sure
you have a
> query license, make sure NO ONE ELSE IS IN VANTAGE, and have a
REALLY GOOD
> BACKUP, you may just be in business.
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@k...]
> Sent: Tuesday, July 31, 2001 4:05 PM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> First of all, this program is trying to write to the database, and
THE
> PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE
TO THE
> DATABASE, according to Doug Williams, director of development. In
order to
> write to the database, you have to purchase provision, and you risk
> corrupting the database and incurring billable support.... etc...
>
> to quote Doug Himself
> "Just a comment on the 4GL coding topic: With a Progress Query
license (the
> license normally shipped with Vantage) you cannot compile programs
that
> update the database. Since you cannot write/run any programs that
change
> any data you don't have to worry about damaging anything and it
being
> billable support, etc."
>
> anyway,
>
> ASSIGN sets the temporary memory value value, and UPDATE transfers
the value
> from memory to the record or screen buffer.
>
> SET does both, assigns the temporary memory value, and updates the
screen or
> record buffer.
>
> I think the lock table overflow error is due to the fact that you
are trying
> to write to the database, or that the for-each statement is locking
more
> records than allowed. You would fix this by using NO-LOCK in your
FOR EACH
> STATEMENT. Of course, NO-LOCK would prevent you from writing to
the DB, so
> combine that with the fact that a Progress Query License doesn't
allow you
> to write to the DB, and you run into some definite feasibility
issues.
>
>
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:43 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> Mark,
> Either one will work I guess. Does the assign function use memory
> differently than the update - set funcition? I gave it a shot as
you
> indicated below, and I got a "cannot find write.p" error. How do
you
> get around the write trigger?
>
> Thanks for your input!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > Is there a reason to use the update and set? I would normally
write
> this as
> > follows:
> >
> > define variable count as integer.
> > assign count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > assign orderrel.make = no.
> > assign count = count + 1.
> > end.
> >
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> >
> >
> > Or am I missing something? I don't know if this has anything to
do
> with your
> > problem or not. Just the first thing I saw when I looked at it.
> >
> > Mark Kohring
> >
> >
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:20 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Lock table overflow
> >
> >
> > We are on Vantage 4.0.904 Progress 9.0B.
> >
> > Thanks Mark!
> >
> > --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > > What version are you on?
> > >
> > > -----Original Message-----
> > > From: acretors@c... [mailto:acretors@c...]
> > > Sent: Tuesday, July 31, 2001 3:07 PM
> > > To: vantage@y...
> > > Subject: [Vantage] Lock table overflow
> > >
> > >
> > > To all,
> > > I have written a small progress program that generates a lock
> table
> > > overflow error (error # 915 I think), and then it bombs out.
Here
> is
> > > the program:
> > >
> > > define variable count as integer.
> > > set count = 0.
> > >
> > > for each orderrel where orderrel.make = yes:
> > > update orderrel
> > > set orderrel.make = no.
> > > set count = count + 1.
> > > end.
> > > Bell.
> > > message "Done. Fixed " count " flags." view-as alert-box.
> > >
> > > I don't remember where to set the -l, so I can't tell you what
it
> is
> > > set to right now. Is this all I need to change, or have I made
a
> > > mistake in my programming? The syntax check says it is ok...
> > >
> > > And please don't ask why I want to flip all these flags, we are
> > > working through some major procedural issues with Vantage, and
> this
> > > is only a temporary (I hope!!) fix.
> > >
> > > Thanks for your help!!!
> > >
> > >
> > >
> > > 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/links
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

system · July 31, 2001, 6:20pm

If you compile your program using xref option and then take a look at the
cross reference, you'll see that the for each is using whole-index. Because
based on the where clause you use, Progress was not able to pick a proper
index. To get around with unexpected locking problem with whole table scan,
you can try something like this:

def var count as inte.
assign count = 0.

for each company no-lock:
for each orderhed where orderhed.company = company.company no-lock:
for each orderdtl where orderdtl.company = orderhed.company and
orderdtl.ordernum = orderhed.ordernum no-lock:
for each orderrel where orderrel.company = orderdtl.company and
orderrel.ordernum = orderdtl.ordernum and
orderrel.orderline = orderdtl.orderline
and
orderrel.make = yes:
orderrel.make = no.
count = count + 1.
end.
end.
end.
end.
bell.
message "Done. Fixed " count " flags." view-as alert-box.

-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Tuesday, July 31, 2001 4:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Lock table overflow

Been trying to catch up on this thread ..

Re the license issue. It's my understanding that what comes with
'basic' Vantage does not provide functionally to compile code,
therefore it's not possible to create such.

It's a question of licensing ability to create code, not licensing
the right to modify your DB.

The reverse would mean no third party developer could legally modify
the DB without the client owning Provision.

Lonnie

--- In vantage@y..., Thad Jacobs <tjacobs@k...> wrote:
> I would check it out, but we don't have a write license, and don't
want or
> need a write license at this point.
>
> Your probably right about the locks, may want to see if no-lock
eliminates
> the lock table overflow nonetheless. I'm not sure, but the program
may be
> trying to lock all the records at once.
>
> Are you using provision, or a standard as-shipped progress license.
Has
> anyone written to the Vantage DB using the standard as-shipped
license?
>
> ~thad
>
>
> -----Original Message-----
> From: Mark Kohring [mailto:mkohring@d...]
> Sent: Tuesday, July 31, 2001 4:25 PM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> I am pretty sure that when you write to the database using a
shared-lock it
> upgrades it to an exclusive-lock while writing and then sets it
back to
> shared. I don't think you can write to it at all using no-lock, but
if you
> can it will probably have to go thru the same upgrade to exclusive
for the
> actual write which would kill the reason for using no-lock in the
first
> place. I might be wrong, but if you've got time to kill check it
out.
>
> Mark
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@k...]
> Sent: Tuesday, July 31, 2001 4:11 PM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> take that back. NO-LOCK would mean that while you are editing the
record
> you are not locking others out. It is standard procedure to lock a
record
> before editing it. If you use a no-lock statement, and make sure
you have a
> query license, make sure NO ONE ELSE IS IN VANTAGE, and have a
REALLY GOOD
> BACKUP, you may just be in business.
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@k...]
> Sent: Tuesday, July 31, 2001 4:05 PM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Re: Lock table overflow
>
>
> First of all, this program is trying to write to the database, and
THE
> PROGRESS LICENSE SUPPLIED WITH VANTAGE DOES NOT ALLOW YOU TO WRITE
TO THE
> DATABASE, according to Doug Williams, director of development. In
order to
> write to the database, you have to purchase provision, and you risk
> corrupting the database and incurring billable support.... etc...
>
> to quote Doug Himself
> "Just a comment on the 4GL coding topic: With a Progress Query
license (the
> license normally shipped with Vantage) you cannot compile programs
that
> update the database. Since you cannot write/run any programs that
change
> any data you don't have to worry about damaging anything and it
being
> billable support, etc."
>
> anyway,
>
> ASSIGN sets the temporary memory value value, and UPDATE transfers
the value
> from memory to the record or screen buffer.
>
> SET does both, assigns the temporary memory value, and updates the
screen or
> record buffer.
>
> I think the lock table overflow error is due to the fact that you
are trying
> to write to the database, or that the for-each statement is locking
more
> records than allowed. You would fix this by using NO-LOCK in your
FOR EACH
> STATEMENT. Of course, NO-LOCK would prevent you from writing to
the DB, so
> combine that with the fact that a Progress Query License doesn't
allow you
> to write to the DB, and you run into some definite feasibility
issues.
>
>
>
>
>
> -----Original Message-----
> From: acretors@c... [mailto:acretors@c...]
> Sent: Tuesday, July 31, 2001 3:43 PM
> To: vantage@y...
> Subject: [Vantage] Re: Lock table overflow
>
>
> Mark,
> Either one will work I guess. Does the assign function use memory
> differently than the update - set funcition? I gave it a shot as
you
> indicated below, and I got a "cannot find write.p" error. How do
you
> get around the write trigger?
>
> Thanks for your input!
>
> --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > Is there a reason to use the update and set? I would normally
write
> this as
> > follows:
> >
> > define variable count as integer.
> > assign count = 0.
> >
> > for each orderrel where orderrel.make = yes:
> > assign orderrel.make = no.
> > assign count = count + 1.
> > end.
> >
> > message "Done. Fixed " count " flags." view-as alert-box.
> >
> >
> >
> > Or am I missing something? I don't know if this has anything to
do
> with your
> > problem or not. Just the first thing I saw when I looked at it.
> >
> > Mark Kohring
> >
> >
> >
> > -----Original Message-----
> > From: acretors@c... [mailto:acretors@c...]
> > Sent: Tuesday, July 31, 2001 3:20 PM
> > To: vantage@y...
> > Subject: [Vantage] Re: Lock table overflow
> >
> >
> > We are on Vantage 4.0.904 Progress 9.0B.
> >
> > Thanks Mark!
> >
> > --- In vantage@y..., "Mark Kohring" <mkohring@d...> wrote:
> > > What version are you on?
> > >
> > > -----Original Message-----
> > > From: acretors@c... [mailto:acretors@c...]
> > > Sent: Tuesday, July 31, 2001 3:07 PM
> > > To: vantage@y...
> > > Subject: [Vantage] Lock table overflow
> > >
> > >
> > > To all,
> > > I have written a small progress program that generates a lock
> table
> > > overflow error (error # 915 I think), and then it bombs out.
Here
> is
> > > the program:
> > >
> > > define variable count as integer.
> > > set count = 0.
> > >
> > > for each orderrel where orderrel.make = yes:
> > > update orderrel
> > > set orderrel.make = no.
> > > set count = count + 1.
> > > end.
> > > Bell.
> > > message "Done. Fixed " count " flags." view-as alert-box.
> > >
> > > I don't remember where to set the -l, so I can't tell you what
it
> is
> > > set to right now. Is this all I need to change, or have I made
a
> > > mistake in my programming? The syntax check says it is ok...
> > >
> > > And please don't ask why I want to flip all these flags, we are
> > > working through some major procedural issues with Vantage, and
> this
> > > is only a temporary (I hope!!) fix.
> > >
> > > Thanks for your help!!!
> > >
> > >
> > >
> > > 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/links
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> > 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/links
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
>
>
>
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · July 31, 2001, 8:57pm

Can I throw in my $0.02 (Cdn) on this one.

Licensing:
If you have a runtime, or run-query, license, the program as written will not compile, never mind giving a lock table error. So we can assume that a full development
environment is available.

Locking
If you do a read with no-lock specified, you cannot perform an update of the record. You get a runtime error. If you omit the lock specification, progress will by default
give you share lock when you initially read the record, and upgrade it to an exclusive lock when you are ready to write the new value back to the database. If you read with
an exclusive-lock, you hold the record exclusively for the length of the transaction. In all cases the lock is released automatically when the the transaction ends. Which
brings us to the question: why is the lock table overflowing in the first place?

The transaction in the example begins at the point where the initial value is assigned to the count variable. Hence the whole program is a transaction, not just the for each
loop. You can fix this in two ways.

1. Add a no-undo qualifier to the definition of the count variable. Then progress does not need to remember the initial value, since we don't need to undo it if the program
fails, and the transaction is now limited to the for each loop.

2. Remove the initialization completely. By default, integers are initialized to zero when they are created. If you want another value, you can add an initial qualifier to
the definition of the variable.

If you really need to adjust the size of the lock table, remember that it is a server side parameter. You can change it in $DLC/startup.pf (please excuse Unix notation) or
on the command line that you start the server with. In either case, the server must be stopped and restarted for the lock table size to change.

HTH

/*=======================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1

system · August 1, 2001, 10:31am

At this point in the thread, for those following it, so may issues with the
code, licensing, corrupting the database, I have to point out, this could be
done with a macro utility. So what if it takes a couple of hours to design
it, and say a 1/2 day to convert all of the parts in your part file. You
avoid all of the issues in this thread. As published may times before I use
Ground Control by Acrasoft. www.acrasoft.com

Patrick

-----Original Message-----
From: william [mailto:william@...]
Sent: Tuesday, July 31, 2001 7:57 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Lock table overflow

Can I throw in my $0.02 (Cdn) on this one.

Licensing:
If you have a runtime, or run-query, license, the program as written will
not compile, never mind giving a lock table error. So we can assume that a
full development
environment is available.

Locking
If you do a read with no-lock specified, you cannot perform an update of the
record. You get a runtime error. If you omit the lock specification,
progress will by default
give you share lock when you initially read the record, and upgrade it to an
exclusive lock when you are ready to write the new value back to the
database. If you read with
an exclusive-lock, you hold the record exclusively for the length of the
transaction. In all cases the lock is released automatically when the the
transaction ends. Which
brings us to the question: why is the lock table overflowing in the first
place?

The transaction in the example begins at the point where the initial value
is assigned to the count variable. Hence the whole program is a transaction,
not just the for each
loop. You can fix this in two ways.

1. Add a no-undo qualifier to the definition of the count variable. Then
progress does not need to remember the initial value, since we don't need to
undo it if the program
fails, and the transaction is now limited to the for each loop.

2. Remove the initialization completely. By default, integers are
initialized to zero when they are created. If you want another value, you
can add an initial qualifier to
the definition of the variable.

If you really need to adjust the size of the lock table, remember that it is
a server side parameter. You can change it in $DLC/startup.pf (please excuse
Unix notation) or
on the command line that you start the server with. In either case, the
server must be stopped and restarted for the lock table size to change.

HTH

/*=======================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1

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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · August 1, 2001, 10:36am

To all,
Thanks for your input!
We do have provision, (but not the source code) so as William said, I
don't think that licensing is an issue.

I tried the no-undo on the variable definition, and the program ran
considerably longer before bombing out. So I think we are on to
something here. I will ask IT to stop and restart the service to
recognize the change to the -L parameter.

The alternate program that was provided with linked from the company
table through to the orderrel table gave me the write.p error.

I got a message from Tim Ligas at Epicor saying not to bypass the
trigger, as you are risking data corruption.

I will keep an eye on the list, and try again tomorrow after the -L
changes take effect.

One last nicety - how hard would it be to indicate to the user that
the program is running, and not hung? My first thought would be to
have have a window pop up and display the order numbers that are
being updated? Or it could just show the count variable as it goes
up...

Thanks again for all you help!!

Andrew

P.S. William, Just how much will $0.02 Cdn buy you in USD? :)

--- In vantage@y..., william <william@p...> wrote:
> Can I throw in my $0.02 (Cdn) on this one.
>
> Licensing:
> If you have a runtime, or run-query, license, the program as
written will not compile, never mind giving a lock table error. So we
can assume that a full development
> environment is available.
>
> Locking
> If you do a read with no-lock specified, you cannot perform an
update of the record. You get a runtime error. If you omit the lock
specification, progress will by default
> give you share lock when you initially read the record, and upgrade
it to an exclusive lock when you are ready to write the new value
back to the database. If you read with
> an exclusive-lock, you hold the record exclusively for the length
of the transaction. In all cases the lock is released automatically
when the the transaction ends. Which
> brings us to the question: why is the lock table overflowing in the
first place?
>
> The transaction in the example begins at the point where the
initial value is assigned to the count variable. Hence the whole
program is a transaction, not just the for each
> loop. You can fix this in two ways.
>
> 1. Add a no-undo qualifier to the definition of the count variable.
Then progress does not need to remember the initial value, since we
don't need to undo it if the program
> fails, and the transaction is now limited to the for each loop.
>
> 2. Remove the initialization completely. By default, integers are
initialized to zero when they are created. If you want another value,
you can add an initial qualifier to
> the definition of the variable.
>
> If you really need to adjust the size of the lock table, remember
that it is a server side parameter. You can change it in
$DLC/startup.pf (please excuse Unix notation) or
> on the command line that you start the server with. In either case,
the server must be stopped and restarted for the lock table size to
change.
>
> HTH
>
> /*=======================================================*/
>
> Specialists in Progress Databases and Software since 1986
>
> William E. Colls william@p...
> PROComputer Systems Tel 613 591 0079
> 67 Willow Glen Dr. Fax 613 591 3924
> Kanata Ontario Canada www.procomsys.com
> K2M 1T1

system · August 1, 2001, 12:27pm

To keep the end user comfortable, I always run these programs from a
button, with a fill-in CurRec set as view-as-text. Update in the
loop with something like:

CurRec:screen-value in frame default-frame = string
(orderrel.ordernum).

It's simple drag-and-drop to create these items. Are you using
AppBuilder/User Interface Builder to create the program or Procedure
Editor?

Back to the licensing issue which I don't think has been explained.
I don't think that purchasing ProVision grants you the RIGHT to
modify your database. That right is inherent - it's just that
without ProVision you don't have the tools.

News Update - Just verified the above with Epicor - 'Nuff Said.

Patrick's macro solution would work, but to me it's cumbersome
compared to a programming solution with ProVision (no offense
intended Patrick). Thank you William for the transaction handling
lecture - take note, you can spend big bucks in an Advanced Progress
Programming class for such.

Lonnie

--- In vantage@y..., acretors@c... wrote:
> To all,
> Thanks for your input!
> We do have provision, (but not the source code) so as William said,
I
> don't think that licensing is an issue.
>
> I tried the no-undo on the variable definition, and the program ran
> considerably longer before bombing out. So I think we are on to
> something here. I will ask IT to stop and restart the service to
> recognize the change to the -L parameter.
>
> The alternate program that was provided with linked from the
company
> table through to the orderrel table gave me the write.p error.
>
> I got a message from Tim Ligas at Epicor saying not to bypass the
> trigger, as you are risking data corruption.
>
> I will keep an eye on the list, and try again tomorrow after the -L
> changes take effect.
>
> One last nicety - how hard would it be to indicate to the user that
> the program is running, and not hung? My first thought would be to
> have have a window pop up and display the order numbers that are
> being updated? Or it could just show the count variable as it goes
> up...
>
> Thanks again for all you help!!
>
> Andrew
>
> P.S. William, Just how much will $0.02 Cdn buy you in USD? :)
>
> --- In vantage@y..., william <william@p...> wrote:
> > Can I throw in my $0.02 (Cdn) on this one.
> >
> > Licensing:
> > If you have a runtime, or run-query, license, the program as
> written will not compile, never mind giving a lock table error. So
we
> can assume that a full development
> > environment is available.
> >
> > Locking
> > If you do a read with no-lock specified, you cannot perform an
> update of the record. You get a runtime error. If you omit the lock
> specification, progress will by default
> > give you share lock when you initially read the record, and
upgrade
> it to an exclusive lock when you are ready to write the new value
> back to the database. If you read with
> > an exclusive-lock, you hold the record exclusively for the length
> of the transaction. In all cases the lock is released automatically
> when the the transaction ends. Which
> > brings us to the question: why is the lock table overflowing in
the
> first place?
> >
> > The transaction in the example begins at the point where the
> initial value is assigned to the count variable. Hence the whole
> program is a transaction, not just the for each
> > loop. You can fix this in two ways.
> >
> > 1. Add a no-undo qualifier to the definition of the count
variable.
> Then progress does not need to remember the initial value, since we
> don't need to undo it if the program
> > fails, and the transaction is now limited to the for each loop.
> >
> > 2. Remove the initialization completely. By default, integers are
> initialized to zero when they are created. If you want another
value,
> you can add an initial qualifier to
> > the definition of the variable.
> >
> > If you really need to adjust the size of the lock table, remember
> that it is a server side parameter. You can change it in
> $DLC/startup.pf (please excuse Unix notation) or
> > on the command line that you start the server with. In either
case,
> the server must be stopped and restarted for the lock table size
to
> change.
> >
> > HTH
> >
> > /*=======================================================*/
> >
> > Specialists in Progress Databases and Software since 1986
> >
> > William E. Colls william@p...
> > PROComputer Systems Tel 613 591
0079
> > 67 Willow Glen Dr. Fax 613 591
3924
> > Kanata Ontario Canada
www.procomsys.com
> > K2M 1T1

Topic		Replies	Views
Progress question Yahoo Archive	8	535	October 10, 2003
4GL Baby steps Yahoo Archive	17	440	January 15, 2002
Procedure Editor Yahoo Archive	8	613	March 16, 2010
Making changes in bulk Yahoo Archive	22	824	March 24, 2011
1-time 4GL program to update ud fields Yahoo Archive	4	499	August 6, 2010

Lock table overflow

Related Topics