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




[Non-text portions of this message have been removed]