PREmpMas Table Blank Title 129494

[system]

Thanks,

 

I got the lib/UpdateTableBuffer code from a co-worker and was trying that out but getting a whole bunch of other errors that were confusing, then I realized it was because I was on a unix box, not a windows box and I had lib\ instead of lib/

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Edginton
Sent: Wednesday, April 09, 2014 8:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] PREmpMas Table

 

Also this table is no different to other except it uses a find trigger that many others don’t.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: 10 April 2014 00:44
To: vantage@yahoogroups.com
Subject: [Vantage] PREmpMas Table

 

 

Version 8.03.410

OpenEdge 10.1B SP3 HF33

Does anyone know if this table is different in some way than others?

I am working on a problem where certain fields were allowed to be extended beyond their set limit, it’s defined as 30 characters, but for some reason the system allowed 45 to be put in the field.

So I am working on this on a bunch of tables, and I am using this for the code to truncate the field value. I am running this through the procedure editor instead of in a BPM since I get the error that “You may not compile programs that update the database in this version(490)” when I try to put the code into a BPM

FOR EACH PREmpMas WHERE LENGTH(PREmpMas.emgcontact) > 30:

        ASSIGN PREmpMas.emgcontact = SUBSTRING(PREmpMas.emgcontact,1,30,'CHARACTER').

END.

However, when I try to run this, I get this for an error.

**”db/trg/PREMPMAS/FIND.P” was not found. (293)

So I have checked that file location, and there is no FIND.P but there is a FIND.R in there.

Any suggestions? This has worked for all other tables I have tried it with, like EmpBasic, InvcHead, cashdtl, APTran, TaxTran.

 

 

Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415 Main:  +44 (0) 121 314 1170 Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

[system]

PREmpMas Table

Version 8.03.410

OpenEdge 10.1B SP3 HF33

Does anyone know if this table is different in some way than others?

I am working on a problem where certain fields were allowed to be extended beyond their set limit, it’s defined as 30 characters, but for some reason the system allowed 45 to be put in the field.

So I am working on this on a bunch of tables, and I am using this for the code to truncate the field value. I am running this through the procedure editor instead of in a BPM since I get the error that “You may not compile programs that update the database in this version(490)” when I try to put the code into a BPM

FOR EACH PREmpMas WHERE LENGTH(PREmpMas.emgcontact) > 30:

        ASSIGN PREmpMas.emgcontact = SUBSTRING(PREmpMas.emgcontact,1,30,'CHARACTER').

END.

However, when I try to run this, I get this for an error.

**”db/trg/PREMPMAS/FIND.P” was not found. (293)

So I have checked that file location, and there is no FIND.P but there is a FIND.R in there.

Any suggestions? This has worked for all other tables I have tried it with, like EmpBasic, InvcHead, cashdtl, APTran, TaxTran.

[system]

#ygrps-yiv-2021105185 P.ygrps-yiv-2021105185ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2021105185 LI.ygrps-yiv-2021105185ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2021105185 DIV.ygrps-yiv-2021105185ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2021105185 TABLE.ygrps-yiv-2021105185ce387540-7764-462c-979a-97379ccda45cTable { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2021105185 DIV.ygrps-yiv-2021105185Section1 { }

HI Ned,

 

You will get the same error about compilation of programs if you use the procedure editor in V8 unless you have developer license.

You are getting the trigger error because the procedure editor is not bootstrapping other logic correctly.

 

There are many ways to fix but one simple one is on V8.

Use a BPM and use the lib/UpdateTableBuffer.r program you can find details about it in the help this will then work.

 

Other ways are dynamically referencing the table to do the update and disabling the triggers in the session.

 

Regards,

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: 10 April 2014 00:44
To: vantage@yahoogroups.com
Subject: [Vantage] PREmpMas Table

 

 

Version 8.03.410

OpenEdge 10.1B SP3 HF33

Does anyone know if this table is different in some way than others?

I am working on a problem where certain fields were allowed to be extended beyond their set limit, it’s defined as 30 characters, but for some reason the system allowed 45 to be put in the field.

So I am working on this on a bunch of tables, and I am using this for the code to truncate the field value. I am running this through the procedure editor instead of in a BPM since I get the error that “You may not compile programs that update the database in this version(490)” when I try to put the code into a BPM

FOR EACH PREmpMas WHERE LENGTH(PREmpMas.emgcontact) > 30:

        ASSIGN PREmpMas.emgcontact = SUBSTRING(PREmpMas.emgcontact,1,30,'CHARACTER').

END.

However, when I try to run this, I get this for an error.

**”db/trg/PREMPMAS/FIND.P” was not found. (293)

So I have checked that file location, and there is no FIND.P but there is a FIND.R in there.

Any suggestions? This has worked for all other tables I have tried it with, like EmpBasic, InvcHead, cashdtl, APTran, TaxTran.

Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415 Main:  +44 (0) 121 314 1170 Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

[system]

#ygrps-yiv-2111360668 P.ygrps-yiv-2111360668ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2111360668 LI.ygrps-yiv-2111360668ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2111360668 DIV.ygrps-yiv-2111360668ce387540-7764-462c-979a-97379ccda45c { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2111360668 TABLE.ygrps-yiv-2111360668ce387540-7764-462c-979a-97379ccda45cTable { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-2111360668 DIV.ygrps-yiv-2111360668Section1 { }

Also this table is no different to other except it uses a find trigger that many others don’t.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: 10 April 2014 00:44
To: vantage@yahoogroups.com
Subject: [Vantage] PREmpMas Table

 

 

Version 8.03.410

OpenEdge 10.1B SP3 HF33

Does anyone know if this table is different in some way than others?

I am working on a problem where certain fields were allowed to be extended beyond their set limit, it’s defined as 30 characters, but for some reason the system allowed 45 to be put in the field.

So I am working on this on a bunch of tables, and I am using this for the code to truncate the field value. I am running this through the procedure editor instead of in a BPM since I get the error that “You may not compile programs that update the database in this version(490)” when I try to put the code into a BPM

FOR EACH PREmpMas WHERE LENGTH(PREmpMas.emgcontact) > 30:

        ASSIGN PREmpMas.emgcontact = SUBSTRING(PREmpMas.emgcontact,1,30,'CHARACTER').

END.

However, when I try to run this, I get this for an error.

**”db/trg/PREMPMAS/FIND.P” was not found. (293)

So I have checked that file location, and there is no FIND.P but there is a FIND.R in there.

Any suggestions? This has worked for all other tables I have tried it with, like EmpBasic, InvcHead, cashdtl, APTran, TaxTran.

Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415 Main:  +44 (0) 121 314 1170 Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.