Yes, that is dialect 3.
Can u convert your Database from dialect 1 to 3 to take advantage of all the
new options ?

-------------------------

----- Original Message -----
From: "Andrea Raimondi" <rainaple@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, July 11, 2004 11:08 AM
Subject: Re: [firebird-support] Average age


| Hans Hoogstraat wrote:
| > I think the ???? can be the internal FB variable 'current_date'
|
| Hi Hans,
|
| First of all, thank you for the prompt answer.
| I am not sure, though, that it can be of any help, since I
| already tried current_date, but when I get to execute it, the
| server says:
|
| "Invalid token.
| Dynamic SQL Error.
| SQL error code = -104.
| Client SQL dialect 1 does not support reference to DATE datatype."
|
| The SQL statement completed with current_date looks like this:
|
| Select avg( ( extract( year from current_date ) - extract(year from
OB) )
| /
| count( * ) )from TblPerson where( Sex = 'Female' )
|
| That's why I added the "additional infos".
|
| TIA,
|
| Andrew
|
|
|
|
|
| Yahoo! Groups Links
|
|
|
|
|