> Would be interesting how they managed to add ACTION as a field in a dialect 1 database then?
The database used to be Interbase (and very old version of Interbase) and was converted a few years ago. Maybe that explains it. RBS On Tue, Nov 15, 2011 at 9:58 AM, Thomas Steinmaurer <[email protected]>wrote: > ** > > > > I think action is a reserved keyword as doing a select a simple select > will > > give: > > > > Dynamic SQL Error > > SQL error code = -104 > > Token unknown - line 1, char 8 > > action > > > > Changing to dialect 3 looks tricky then and best to leave it till this is > > done by our > > software supplier. > > Would be interesting how they managed to add ACTION as a field in a > dialect 1 database then? Possibly connecting to the database with a > newer Firebird version, because e.g. in Firebird 2.5, I can add a field > ACTION in a dialect 1 database without problems. > > This all looks a bit fishy. ;-) > > > -- > 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/ > > > RBS > > On Tue, Nov 15, 2011 at 9:14 AM, Thomas Steinmaurer<[email protected] > >wrote: > > > >> ** > > >> > >> > >>> 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? > >> > >> Yes in general, it's a property at database level, but in practice, it's > >> more complicated, because: > >> > >> - The DATE data type only holds the date portion while in dialect 1 it > >> is date and time > >> - Using double-quotes for string delimiters fails in dialect 3, because > >> dialect 3 treats them as object names instead of string literals > >> - Numeric representation changed > >> > >> etc ... > >> > >> Switching to dialect 3 usually means: > >> > >> - Migrating data to dialect 3 > >> - Entirely re-test the application > >> > >> I wonder if you can do a simple: > >> > >> select action from audit_trial > >> > >> In a Firebird 1.5 database? That said, I can't remember if ACTION is a > >> reserved keyword in 1.5. > >> > >> > >> -- > >> 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/ > >> > >>> 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 > >>> > >>> > >>> > >> > >> > >> > > > > > > [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 > > > > > > > > > [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/
