http://firebird.sourceforge.net/

>What is firebird???
>
>>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 :).