Both databases are the same dialect.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Friday, January 27, 2006 2:23 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Similar SQL query fails

> This verion (different database, same version of Firebird) works, no
> error.

If the view doesn't make the difference, is there perhaps a difference
in database dialect upon creation?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL Server Upscene Productions http://www.upscene.com Database
development questions? Check the forum!
http://www.databasedevelopmentforum.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links