Hi

>Is there any more pitfalls i have to know? firebird seems not to allow indexes of the same name even when those are of different tables..such as when i index a date field on table x, i wouldn't be able to index a date field on table y.
>is this normal?

Firebird object names are unique by design. Tablex, indices, stored procedures, triggers. You need to know this. Think about the index as VFP index files, not tags.

There are many reserved words that you can find in documentation.
You can use reserved names though, using double quotes, "date" is valid but also become case sensitive and the use of double quotes is mandatory.

After you will know it better, I'me sure you will like it :).