Thanks for the feedback. The senior programmer made things easy on me
by telling me to change the reserved words. Again this is a move from
IB 7.5 to FB 2.0 and we are trying to minimize any changes do the DDL
(there for minimizing changes to our code base).

Shariful Alam wrote:

> DAY, MONTH, YEAR are Firebird Reserved word, that's why it is showing on quote. Replace the variable name. Do not use any keyword as variable or procedure name or field name. Firebird will make this in quote.
>
> Best Regards
> Md. Shariful Alam Khan
>
>
> ----- Original Message ----
> From: Thomas Miller <tmiller@...>
> To: firebird-support@yahoogroups.com
> Sent: Wednesday, August 2, 2006 7:02:14 PM
> Subject: [firebird-support] Reserved words and Procedures
>
> My continuing saga of moving a database from IB 7.5 to FB2
>
> There are a hand full of procedure that mimic many of Delphi's basic
> DateTime subroutines.
>
> One procedure is even called "DAY". Many of the return variables are
> called "DAY", "MONTH", and "YEAR".
>
> How much of this stuff can I keep by quoting them? Is it single quotes
> or double quotes? Suggestions welcome.
>
> Thanks for you input.
>
>

--
Thomas Miller
Chrome Portal Project Manager
CPCUG Programmers SIG Chairperson (formally Delphi)
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://programmers.cpcug.org/
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus