Home > Archive > SQL Anywhere database > May 2005 > Trigger Problem with SQL Anywhere version 5 to version 7 upgrade









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Trigger Problem with SQL Anywhere version 5 to version 7 upgrade
Lou Pompa

2005-05-23, 9:23 am

Good morning, I am having a problem that my third party software vendor
cannot resolve and I am looking for some help and some recommendations on
tools for me to use to help facilitate a solutions.

We are converting from SQL Anywhere 5 to 7 and in this process our
customized triggers are not working. I would like help doing the following:

1. How can I review and document the triggers that I currently have
running in my live (Version 5) environement?
2. What resources can I obtain to help me rewrite/debug these custom
triggers in a test environement?

Thanks



Stephen Rice

2005-05-23, 8:23 pm

Given you have implemented custom triggers you must have a full-use copy of
ASA and dba access to the database, therefore you can look at the code with
Sybase Central or use dbunload -n to get the schema and use your favourite
editor.

I can't recall any specific changes made between 5 and 7 that would cause a
trigger to fail other than a general tightening up of syntax.

V7 includes an interactive debugger that you can use to step through your
triggers.

Good luck

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
------------ Please Post -------------
"Lou Pompa" <lpompa@llgroup.net> wrote in message
news:4291e81d$1@foru
ms-1-dub...
> Good morning, I am having a problem that my third party software vendor
> cannot resolve and I am looking for some help and some recommendations on
> tools for me to use to help facilitate a solutions.
>
> We are converting from SQL Anywhere 5 to 7 and in this process our
> customized triggers are not working. I would like help doing the
> following:
>
> 1. How can I review and document the triggers that I currently have
> running in my live (Version 5) environement?
> 2. What resources can I obtain to help me rewrite/debug these custom
> triggers in a test environement?
>
> Thanks
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com