Thanks, this just confirms what I already thought. :-(
This would be an excellent feature to add! Many times I would have been
glad to be able to interpret a certain string as an SQL object.
But isn't there something similar in FB 1.5, whereby a string can be
interpreted as an SQL query, and executed? It would be nice to go one
step further!

Thanks!

Jonathan Neve.

Helen Borrie wrote:

>At 08:14 AM 7/11/2003 +0100, you wrote:
>
>
>>Hi!
>>
>>Is there any way, within a trigger, to interpret a string as a field name?
>>For example, I'd like to be able to scroll through the list of fields
>>for my table in the Update trigger, and make a list of those that have
>>been modified (comparing new and old). Is this at all possible? Or is
>>there some other way of getting a list of modified fields?
>>
>>
>
>There is no way to create run-time references to metadata objects in PSQL.
>If you want to perform this test in a trigger, you will have to hard-code
>it for each column in your PSQL code. You could, however, create a
>client-side utility routine for yourself, to build a script for creating
>such BEFORE UPDATE triggers for each of your volatile tables. Your program
>can query RDB$RELATION_FIELDS to get all of the column names for a table.
>
>heLen
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>

[Non-text portions of this message have been removed]