Hi
I would like to create a trigger before data for a new client is written to the database.
We are using Goldmine and Heat as an integrated application and what we have found is that for client names with an apostrophe Goldmine creates an account number with an apostrophe which creates problems in Heat as we all know the famous apostrophe bug. So i'm trying to intercept this with a trigger. I would appreciate if someone could walk me through the process of creating this trigger which will look for a account no in the database with an apostrophe and replace it with some other character.
I would like to create a trigger before data for a new client is written to the database.
We are using Goldmine and Heat as an integrated application and what we have found is that for client names with an apostrophe Goldmine creates an account number with an apostrophe which creates problems in Heat as we all know the famous apostrophe bug. So i'm trying to intercept this with a trigger. I would appreciate if someone could walk me through the process of creating this trigger which will look for a account no in the database with an apostrophe and replace it with some other character.