> 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 <ts@...>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<ts@...
> >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<
> bart.smissaert@...
> >>> 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<
> ts@...
> >>>>> 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]