OK, Action was a bad choice of field name, but this was not ourselves but the company that provides this software, iSoft. Is the only option then to change the database to dialect 3? Is that possible?
RBS On Tue, Nov 15, 2011 at 8:49 AM, Bart Smissaert <[email protected]>wrote: > > Use non-reserved keywords as object names in a dialect 1 database > > Is there a way to do that? > > RBS > > On Tue, Nov 15, 2011 at 8:43 AM, Thomas Steinmaurer <[email protected] > > wrote: > >> ** >> >> >> > Running Firebird 1.5, classic, dialect 1 on Windows and trying to >> > create a trigger like this: >> > >> > CREATE TRIGGER EXTENDED_TEXT_DEL FOR EXTENDED_TEXT >> > ACTIVE BEFORE DELETE >> > POSITION 10 >> > AS >> > begin >> > insert into audit_trail >> > (Table_Id,"Action",Primary_Key,data) >> > values (45, 1, >> > old.Extended_Text_Type||"|"|| >> > old.Foreign_Id||"|"|| >> > old.Extended_Text_Sequence_No, >> > old.Extended_Text_Type||"|"|| >> > old.Foreign_Id||"|"|| >> > old.Extended_Text_Sequence_No||"|"|| >> > old.Free_Text >> > ); >> > END >> > >> > which will give the following error: >> > >> > Dynamic SQL Error >> > SQL error code = -817 >> > Metadata update statement is not allowed by the current database SQL >> dialect 1. >> > >> > Note the double quotes around the field name Action. >> > >> > Any idea how I can run this statement? >> >> You can't with dialect 1. Delimited identifiers are supported by dialect >> 3. Use non-reserved keywords as object names in a dialect 1 database. >> >> -- >> With regards, >> Thomas Steinmaurer >> >> * Upscene Productions - Database Tools for Developers >> http://www.upscene.com/ >> >> * My Blog >> http://blog.upscene.com/thomas/index.php >> >> * Firebird Foundation Committee Member >> http://www.firebirdsql.org/en/firebird-foundation/ >> >> >> > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
