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

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
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
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]
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