Subject | AW: [firebird-support] Temporary Field - Check Field Exist |
---|---|
Author | Steffen Heil |
Post date | 2004-11-04T14:29:58Z |
Hi
You cannot - or at least, you should not.
Creating a field means changing meta-data.
Changing meta-data is only allowed in single connections and changes will
not be available until you reconnect to the database. However, you cannot
reconnect while you Stored Procedure is running. Hence to temporary field.
Use a permanent table with an SPinvocation number (returned from a
generator).
Regards,
Steffen
[Non-text portions of this message have been removed]
> I need to create in a Stored Procedure a temporary field, how can I doknown if it exist before to create it ?
You cannot - or at least, you should not.
Creating a field means changing meta-data.
Changing meta-data is only allowed in single connections and changes will
not be available until you reconnect to the database. However, you cannot
reconnect while you Stored Procedure is running. Hence to temporary field.
Use a permanent table with an SPinvocation number (returned from a
generator).
Regards,
Steffen
[Non-text portions of this message have been removed]