Three questions,

How is this domain defined: DM_EMAIL?
How is PersonInfo.Email defined?
What does this SP do? PersonInfoChanged

Adam



--- In firebird-support@yahoogroups.com, "Ed Dressel" <dressel@p...>
wrote:

> I am adding a field to a table in (Delphi) code (below--its a bit
> different in my app but essentially the same) to be an upper
> case representation of the email address so I can serarch by email.
>
> After adding the field and updating the triggers, I try an update SQL:
>
> Update PersonInfo set EMailUpper=Email
>
> but get an exception:
>
> ISC ERROR CODE:335544334ISC ERROR MESSAGE:conversion error from
> string "This@t...".
>
> "This@T..." is just some test data I put in the Email field for
> testing.
>
> After I alter the database, if I go IBExpert and run the update DSQL,
> it works fine.
>
> Any suggestions on what I am doing wrong?
>
> Thanks
> Ed Dressel
>
>
>
> alter table PersonInfo add EMailUpper DM_EMAIL;
> create index EMailUpperIdx on PersonInfo(EMailUpper);
>
> drop trigger TRIG_PERSONINFO_AU;
> drop trigger TRIG_PERSONINFO_BI;
>
> set term ^;
>
> CREATE TRIGGER TRIG_PERSONINFO_BI FOR PERSONINFO
> ACTIVE BEFORE INSERT POSITION 0
> AS BEGIN
> IF(NEW.PERSON_ID IS NULL) THEN NEW.PERSON_ID =

GEN_ID(GEN_PERSON_ID,1);

> NEW.EMAILUPPER= UPPER(NEW.EMAIL);
> END^
>
>
> CREATE TRIGGER TRIG_PERSONINFO_BU FOR PERSONINFO
> ACTIVE BEFORE UPDATE POSITION 0
> AS BEGIN
> execute procedure PersonInfoChanged(NEW.PERSON_ID);
> New.EmailUpper=Upper(New.EMail);
> END^
>
> set term ;^
>
> commit;
>
> Update PersonInfo set EMailUpper=Email //exception here