> Still, having a field ACTION in a Firebird 1.5 dialect 1 is useless then, because you can't use it. ;-)
Well, it is used continuously as this is an audit trail table. It has continous inserts when other tables have changes. I can also do a select * So, it is not really useless. RBS On Tue, Nov 15, 2011 at 10:05 AM, Thomas Steinmaurer <[email protected]>wrote: > ** > > > >> 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. > > Perhaps, yes. Still, having a field ACTION in a Firebird 1.5 dialect 1 > is useless then, because you can't use it. ;-) > > Regards, > Thomas > > > > 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 > > > > > > > > > [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/
