Progress Update to Part Table (has trigger)

Yahoo Archive
1
Thanks, this works.

--- In vantage@yahoogroups.com, "netrippers" <netrippers@...> wrote:
>
> You can disable any progress triggers with this code.
>
> Use at your own risk!
>
> Put this code at the beginning of your procedure to disable the trigger.
> ON WRITE OF Part OVERRIDE DO: END.
>
> Add this to the end to enable the trigger again.
> ON WRITE OF Part REVERT.
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.
> >
> > From: Nancy Dornacker
> > Sent: Wednesday, November 16, 2011 8:04 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Progress Update to Part Table (has trigger)
> >
> >
> > I need to update the field part.prodcode
> >
> > When I go to update we get the error able a trigger on the table
> >
> > Db\trg\part\write.p was not found (293)
> >
> > Does anyone know of a way you can update the part.prodcode field through
> > Progress when the table has a trigger on it? We need to mass update
> > about 500 records.
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >
> > Nancy Dornacker
> >
> > IT Support Specialist
> >
> > Steel Craft Corporation
> >
> > 105 Steel Craft Drive
> >
> > Hartford, WI 53027
> >
> > (P) 262-673-6770 ext 132
> >
> > (F) 262-673-4380
> >
> > http://www.scc-wi.com <http://www.scc-wi.com/>
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
I need to update the field part.prodcode



When I go to update we get the error able a trigger on the table

Db\trg\part\write.p was not found (293)



Does anyone know of a way you can update the part.prodcode field through
Progress when the table has a trigger on it? We need to mass update
about 500 records.



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

Nancy Dornacker

IT Support Specialist

Steel Craft Corporation

105 Steel Craft Drive

Hartford, WI 53027

(P) 262-673-6770 ext 132

(F) 262-673-4380

http://www.scc-wi.com <http://www.scc-wi.com/>





[Non-text portions of this message have been removed]
3
Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.

From: Nancy Dornacker
Sent: Wednesday, November 16, 2011 8:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress Update to Part Table (has trigger)


I need to update the field part.prodcode

When I go to update we get the error able a trigger on the table

Db\trg\part\write.p was not found (293)

Does anyone know of a way you can update the part.prodcode field through
Progress when the table has a trigger on it? We need to mass update
about 500 records.

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

Nancy Dornacker

IT Support Specialist

Steel Craft Corporation

105 Steel Craft Drive

Hartford, WI 53027

(P) 262-673-6770 ext 132

(F) 262-673-4380

http://www.scc-wi.com <http://www.scc-wi.com/>

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




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11


[Non-text portions of this message have been removed]
4
You can disable any progress triggers with this code.

Use at your own risk!

Put this code at the beginning of your procedure to disable the trigger.
ON WRITE OF Part OVERRIDE DO: END.

Add this to the end to enable the trigger again.
ON WRITE OF Part REVERT.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.
>
> From: Nancy Dornacker
> Sent: Wednesday, November 16, 2011 8:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Progress Update to Part Table (has trigger)
>
>
> I need to update the field part.prodcode
>
> When I go to update we get the error able a trigger on the table
>
> Db\trg\part\write.p was not found (293)
>
> Does anyone know of a way you can update the part.prodcode field through
> Progress when the table has a trigger on it? We need to mass update
> about 500 records.
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- --
>
> Nancy Dornacker
>
> IT Support Specialist
>
> Steel Craft Corporation
>
> 105 Steel Craft Drive
>
> Hartford, WI 53027
>
> (P) 262-673-6770 ext 132
>
> (F) 262-673-4380
>
> http://www.scc-wi.com <http://www.scc-wi.com/>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11
>
>
> [Non-text portions of this message have been removed]
>
5
How are you able to get by the write triggers to allow you to edit records?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, November 16, 2011 10:24 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress Update to Part Table (has trigger)





Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.

From: Nancy Dornacker
Sent: Wednesday, November 16, 2011 8:04 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Progress Update to Part Table (has trigger)

I need to update the field part.prodcode

When I go to update we get the error able a trigger on the table

Db\trg\part\write.p was not found (293)

Does anyone know of a way you can update the part.prodcode field through
Progress when the table has a trigger on it? We need to mass update
about 500 records.

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

Nancy Dornacker

IT Support Specialist

Steel Craft Corporation

105 Steel Craft Drive

Hartford, WI 53027

(P) 262-673-6770 ext 132

(F) 262-673-4380

http://www.scc-wi.com <http://www.scc-wi.com/>

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11

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





[Non-text portions of this message have been removed]
6
Openedge ODBC manages all that. Not in my layer. If you come from a MS SQL world where you love to free-form type in SQL queries for forensics, analysis, updates and exports; then this is your tool. You just have to be extremely cognizant of WTH you’re doing otherwise.... :-)



From: Mike Anstey
Sent: Wednesday, November 16, 2011 1:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress Update to Part Table (has trigger)


How are you able to get by the write triggers to allow you to edit records?



From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, November 16, 2011 10:24 AM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Progress Update to Part Table (has trigger)





Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.

From: Nancy Dornacker
Sent: Wednesday, November 16, 2011 8:04 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Progress Update to Part Table (has trigger)

I need to update the field part.prodcode

When I go to update we get the error able a trigger on the table

Db\trg\part\write.p was not found (293)

Does anyone know of a way you can update the part.prodcode field through
Progress when the table has a trigger on it? We need to mass update
about 500 records.

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

Nancy Dornacker

IT Support Specialist

Steel Craft Corporation

105 Steel Craft Drive

Hartford, WI 53027

(P) 262-673-6770 ext 132

(F) 262-673-4380

http://www.scc-wi.com <http://www.scc-wi.com/>

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11

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




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




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4620 - Release Date: 11/16/11


[Non-text portions of this message have been removed]
7
Hmmm… you must have something set different than I do, when I try in Squirrel, I get an error. What version of Vantage (or epicor) are running?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, November 16, 2011 2:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress Update to Part Table (has trigger)





Openedge ODBC manages all that. Not in my layer. If you come from a MS SQL world where you love to free-form type in SQL queries for forensics, analysis, updates and exports; then this is your tool. You just have to be extremely cognizant of WTH you’re doing otherwise.... :-)

From: Mike Anstey
Sent: Wednesday, November 16, 2011 1:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Progress Update to Part Table (has trigger)

How are you able to get by the write triggers to allow you to edit records?

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, November 16, 2011 10:24 AM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Progress Update to Part Table (has trigger)

Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.

From: Nancy Dornacker
Sent: Wednesday, November 16, 2011 8:04 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Progress Update to Part Table (has trigger)

I need to update the field part.prodcode

When I go to update we get the error able a trigger on the table

Db\trg\part\write.p was not found (293)

Does anyone know of a way you can update the part.prodcode field through
Progress when the table has a trigger on it? We need to mass update
about 500 records.

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

Nancy Dornacker

IT Support Specialist

Steel Craft Corporation

105 Steel Craft Drive

Hartford, WI 53027

(P) 262-673-6770 ext 132

(F) 262-673-4380

http://www.scc-wi.com <http://www.scc-wi.com/>

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11

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

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1869 / Virus Database: 2092/4620 - Release Date: 11/16/11

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





[Non-text portions of this message have been removed]
8
> I need to update the field part.prodcode
You are Progress?
Have you tried an ODBC connection with a blank Isolation Level?
I have used this along with update queries in MSAccess to perform mass updates in the past without any issues.



And... the usual cautions about updating fields directly, making sure there aren't related updates required, etc...
I do it after hours because of record locks.
And... I don't remember if I updated the Product Code.

--- In vantage@yahoogroups.com, "Mike Anstey" <manstey@...> wrote:
>
> Hmmm… you must have something set different than I do, when I try in Squirrel, I get an error. What version of Vantage (or epicor) are running?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Wednesday, November 16, 2011 2:55 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress Update to Part Table (has trigger)
>
>
>
>
>
> Openedge ODBC manages all that. Not in my layer. If you come from a MS SQL world where you love to free-form type in SQL queries for forensics, analysis, updates and exports; then this is your tool. You just have to be extremely cognizant of WTH you’re doing otherwise.... :-)
>
> From: Mike Anstey
> Sent: Wednesday, November 16, 2011 1:40 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Progress Update to Part Table (has trigger)
>
> How are you able to get by the write triggers to allow you to edit records?
>
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Wednesday, November 16, 2011 10:24 AM
> To: mailto:vantage%40yahoogroups.com
> Subject: Re: [Vantage] Progress Update to Part Table (has trigger)
>
> Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.
>
> From: Nancy Dornacker
> Sent: Wednesday, November 16, 2011 8:04 AM
> To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress Update to Part Table (has trigger)
>
> I need to update the field part.prodcode
>
> When I go to update we get the error able a trigger on the table
>
> Db\trg\part\write.p was not found (293)
>
> Does anyone know of a way you can update the part.prodcode field through
> Progress when the table has a trigger on it? We need to mass update
> about 500 records.
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- --
>
> Nancy Dornacker
>
> IT Support Specialist
>
> Steel Craft Corporation
>
> 105 Steel Craft Drive
>
> Hartford, WI 53027
>
> (P) 262-673-6770 ext 132
>
> (F) 262-673-4380
>
> http://www.scc-wi.com <http://www.scc-wi.com/>
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1869 / Virus Database: 2092/4620 - Release Date: 11/16/11
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
You just need to disable the triggers. The syntax is as follows:

DISABLE TRIGGERS FOR LOAD OF orderrel.

--- In vantage@yahoogroups.com, "Mike Anstey" <manstey@...> wrote:
>
> How are you able to get by the write triggers to allow you to edit records?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Wednesday, November 16, 2011 10:24 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress Update to Part Table (has trigger)
>
>
>
>
>
> Yep, use the Squirrel Client. Search back a week or two ago and you’ll find my install directions. I do this all the time.
>
> From: Nancy Dornacker
> Sent: Wednesday, November 16, 2011 8:04 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Progress Update to Part Table (has trigger)
>
> I need to update the field part.prodcode
>
> When I go to update we get the error able a trigger on the table
>
> Db\trg\part\write.p was not found (293)
>
> Does anyone know of a way you can update the part.prodcode field through
> Progress when the table has a trigger on it? We need to mass update
> about 500 records.
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- --
>
> Nancy Dornacker
>
> IT Support Specialist
>
> Steel Craft Corporation
>
> 105 Steel Craft Drive
>
> Hartford, WI 53027
>
> (P) 262-673-6770 ext 132
>
> (F) 262-673-4380
>
> http://www.scc-wi.com <http://www.scc-wi.com/>
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1869 / Virus Database: 2092/4619 - Release Date: 11/15/11
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>