Hi All, I have a table, Parts, with 30 fields in it.
One is named: ExtraData5 and it's varchar(20). the Parts table has millions and millions of rows and ExtraData5 is in each. here's my question... when a normal statement: select * from parts where _some conditions_ is executed? the literal table data for the column ExtraData5 is returned (along with all other columns) What i want to do is override the data being returned from ExtraData5 and i do not want to do it at the select statement. i want a stored procedure to be called when data is being returned for ExtraData5. i know i can write this: select iif( (char_length(ExtraData5)<10), 'Less than 10', Extradata5) as ExtraData5 from Parts but i have 1000s of places i'd have to change code. is there a way i can write a StoredProcedure or trigger to have the "code" in the database return that value i want for the existing column and not just return the table data for that column? sort of like a OnGetText() for the field BUT at the Firebird table level, not in the field in the query in my development environment. FB 2.5 plus, i cannot do this: select *, iif( (char_length(ExtraData5)<10), 'Less than 10', Extradata5) as ExtraData5 from Parts thank you in advance, i always learn a ton from this forum!!
