Updating database with the procedure editor

system · October 11, 2012, 3:46pm

Is there really any reason Epicor does not like when you do this using the procedure editor? I can understand not wanting to do it to a table like JobEntry that relies on their business logic. But I don't see an issue with updating a UD table field where no business logic exists.

________________________________
From: Mike Anstey <manstey@...>
To: vantage@yahoogroups.com
Sent: Thursday, October 11, 2012 3:34 PM
Subject: RE: [Vantage] Updating database with the procedure editor

Add the following to the top of you procedure:

DISABLE TRIGGERS FOR LOAD OF UD03.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tkoch77
Sent: Thursday, October 11, 2012 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updating database with the procedure editor

Â

I have wrote a simple 4GL command and having trouble getting it to run
and Epicor wont help me. I am trying to update checkbox01 in table UD03.

I get an error message that states:

**"db/trg/ud03/write.p" was not found. (293)

If I go to the ud03 folder there is a write.r file but no .p file.

Am I missing something here?

Thanks,

-Ted

[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/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

system · October 11, 2012, 3:26pm

I have wrote a simple 4GL command and having trouble getting it to run and Epicor wont help me. I am trying to update checkbox01 in table UD03.

I get an error message that states:

**"db/trg/ud03/write.p" was not found. (293)

If I go to the ud03 folder there is a write.r file but no .p file.

Am I missing something here?

Thanks,

-Ted

system · October 11, 2012, 3:34pm

Add the following to the top of you procedure:

DISABLE TRIGGERS FOR LOAD OF UD03.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tkoch77
Sent: Thursday, October 11, 2012 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updating database with the procedure editor

I have wrote a simple 4GL command and having trouble getting it to run
and Epicor wont help me. I am trying to update checkbox01 in table UD03.

I get an error message that states:

**"db/trg/ud03/write.p" was not found. (293)

If I go to the ud03 folder there is a write.r file but no .p file.

Am I missing something here?

Thanks,

-Ted

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

system · October 11, 2012, 3:36pm

Wow that was easy. Thanks Mike!

________________________________
From: Mike Anstey <manstey@...>
To: vantage@yahoogroups.com
Sent: Thursday, October 11, 2012 3:34 PM
Subject: RE: [Vantage] Updating database with the procedure editor

Add the following to the top of you procedure:

DISABLE TRIGGERS FOR LOAD OF UD03.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tkoch77
Sent: Thursday, October 11, 2012 4:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updating database with the procedure editor

Â

I have wrote a simple 4GL command and having trouble getting it to run
and Epicor wont help me. I am trying to update checkbox01 in table UD03.

I get an error message that states:

**"db/trg/ud03/write.p" was not found. (293)

If I go to the ud03 folder there is a write.r file but no .p file.

Am I missing something here?

Thanks,

-Ted

[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/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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