4GL Programming help

Yahoo Archive
1
Why don't you just delete the company through the Vantage menu?

Ronald van der Linden


-----Original Message-----
From: Jeff Lewis [mailto:jeff@...]
Sent: woensdag 6 oktober 2004 18:47
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 4GL Programming help.


Jeremy,

I would explicitly call out which company you are trying to delete and
add an Exclusive-Lock. Such as...

for each ABCCODE where ABCCODE.Company = "TheOtherOne"
Exclusive-lock:
/* DISPLAY ABCCODE */
/* with 2 col. */
Delete ABCCODE.
End.

Be aware of any DB Triggers which may fire and practice on you test
database.

Jeff

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]

Sent: Wednesday, October 06, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL Programming help.


Any Progress 4GL gurus out there?

I need to execute this statement:

FOR EACH ABCCODE WHERE COMPANY <> "FAH":
Delete ABCCODE.
End.

It runs but it takes along time. I am trying to purge all
records from each table in the database that does not belong to company
"FAH".
I am just using ABCCODE as an example table.

Does anyone know of a faster statement? I do have Provision.

Thanks
Jeremy



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




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

I need to execute this statement:

FOR EACH ABCCODE WHERE COMPANY <> "FAH":
Delete ABCCODE.
End.

It runs but it takes along time. I am trying to purge all records from each table in the database that does not belong to company "FAH".
I am just using ABCCODE as an example table.

Does anyone know of a faster statement? I do have Provision.

Thanks
Jeremy
3
If in multi-user mode, you're expanding the "Before Image" file since
Progress will back out all updates if it aborts... add a 'TRANSACTION'
option to the FOR statement to minimize this.

If in single-user mode, use the -i (No Crash Protection) option to eliminate
the same overhead... but backup the file before you start.

Also, you could use a Dump and Load kit which dumps all records to text
files. Then remove the company's records from them... don't even need
ProVision for that.

----- Original Message -----
From: "Jeremy Leonard" <jeremy.leonard@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, October 06, 2004 8:08 AM
Subject: [Vantage] 4GL Programming help.


>
> Any Progress 4GL gurus out there?
>
> I need to execute this statement:
>
> FOR EACH ABCCODE WHERE COMPANY <> "FAH":
> Delete ABCCODE.
> End.
>
> It runs but it takes along time. I am trying to purge all records from
each table in the database that does not belong to company "FAH".
> I am just using ABCCODE as an example table.
>
> Does anyone know of a faster statement? I do have Provision.
>
> Thanks
> Jeremy
>
>
>
>
>
>
> 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
> Yahoo! Groups Links
>
>
>
>
>
>
>
4
Jeremy,

I would explicitly call out which company you are trying to delete and
add an Exclusive-Lock. Such as...

for each ABCCODE where ABCCODE.Company = "TheOtherOne"
Exclusive-lock:
/* DISPLAY ABCCODE */
/* with 2 col. */
Delete ABCCODE.
End.

Be aware of any DB Triggers which may fire and practice on you test
database.

Jeff

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]

Sent: Wednesday, October 06, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL Programming help.


Any Progress 4GL gurus out there?

I need to execute this statement:

FOR EACH ABCCODE WHERE COMPANY <> "FAH":
Delete ABCCODE.
End.

It runs but it takes along time. I am trying to purge all
records from each table in the database that does not belong to company
"FAH".
I am just using ABCCODE as an example table.

Does anyone know of a faster statement? I do have Provision.

Thanks
Jeremy



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