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 :).
Peter Cortiel