Data Import / disabling and re-enabing triggers on a table

Yahoo Archive
1
Yes, this is true.

And the epicor statement I love is support will be billable on an hourly
basis :)

This is why we use a script program.

We create flat file and have the script program make the changes in vantage
for us.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: Gavin Davidson [mailto:gavinjd68@...]
Sent: Thursday, June 09, 2005 1:36 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Data Import / disabling and re-enabing triggers on a
table


Jeremy,

That was my understanding too.

Thanks
--- jeremyrleonard@... wrote:


---------------------------------
If you use the Progress ODBC Driver it does not fire
any triggers. That
being said, say a prayer before, after and during and
hope you don't have any
problems as Epicor will not support a database that
has data imported into it via
a method that bypasses their triggers.

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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


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
I am trying to import some data to Vantage 8 and want to temporarily
drop / disable the triggers on a table before I do the import and then
re-enable them afterwards.

Is there aSQL command to do this?

Or can it be done through the progress explorer?

Thanks

Gavin
3
If you use the Progress ODBC Driver it does not fire any triggers. That
being said, say a prayer before, after and during and hope you don't have any
problems as Epicor will not support a database that has data imported into it via
a method that bypasses their triggers.

Jeremy


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

That was my understanding too.

Thanks
--- jeremyrleonard@... wrote:


---------------------------------
If you use the Progress ODBC Driver it does not fire
any triggers. That
being said, say a prayer before, after and during and
hope you don't have any
problems as Epicor will not support a database that
has data imported into it via
a method that bypasses their triggers.

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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com