--- In firebird-support@yahoogroups.com, "anthony.bydeveldt" <anthony.bydeveldt@...> wrote:

>
> Well, apparently the backups are created by GBAK.
>
> but this is what is happening:
>
> C:\Program Files (x86)\Firebird\bin>gbak -c -v -user SYSDBA -password masterkey c:\temp\retdata.bak c:\temp\test.fdb
> gbak: opened file c:\temp\retdata.bak
> gbak: cannot open backup file C:\temp\test.fdb
> gbak: Exiting before completion due to errors
>
> In the manual it says that the destination db must not exists, and it doesn't. In addition, why does it refer to the destination path as the backup file?
>
> once again, thanks for your help.
>

Just 1 more question guys!

Can anyone tell me which SQL standard the ambiguity rule relating to table aliases was introduced?

I understand that the rule wasn't enforced until firebird v2, but I wanted to know which SQL standard that was introduced into.

I am planning on getting the developer to change the software based on it not being SQL standard compliant, as we will be using this software into the foreseeable future and we don't want to get stuck on a 2004 version database server.

Anthony