On Fri, 2002-07-12 at 17:33, Helen Borrie wrote:

> Another very good thing to do when changing over to Firebird from legacy
> InterBase is to study the release notes. There is a section there
> dedicated to the new keywords, which includes also a list of words which
> the FB programmers recommend treating as reserved, since they will be used
> for implementing planned enhancements to the language.

Yes, I said it before, but again for clarity,

It was definitely no doubt my fault on many fronts, one of which was not
reading every aspect of the Release Notes. I had them, but I am not sure
why that I did not pick up on the keywords I was already using.

> William, there are other "traps" you should look out for in the
> IB-to-Firebird transition. Firebird is more fussy than IB about ambiguous
> SQL...and there other places where Firebird requires more care than IB
> did. Please don't complain that these things are undocumented.

No, I will not complain, and I am very sorry for past post. I did go
back through the release notes, after my initial posts, and slapped
myself a few times for not seeing it sooner. :)

> They are
> documented. However, you can get a horse to the water but you can't force
> it to drink...

Yes, I know. I am drinking, and you do not have to drag me to the water.

And again for the last time, it was all my fault. I know it, I have
admitted it, and I have corrected almost all of it already. :)

Luckily from my days of reading each line, I was able to do what I
needed to correct things in the db's quickly.

Now I just have to bring all clients up to speed with the corrected
versions of the gui's that I am compiling now.

In fact I am back running Firebird again, and things are going well.

I am pretty sure that was my only hick-up in the IB to FB conversion.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com