Subject Re: FB 1 and INSERT INTO
Author regmia
This ability has to stay if Firebird is going to progress to
accessing multiple databases from a single statement.

ex. insert into database2.table1 (database2.table1.field1,
database2.table1.field2,...)VALUES(...)

At least this is how SQL Server does it.




--- In ib-support@y..., Nando Dessena <nandod@d...> wrote:
> Helen,
>
> > Sorry, non-ibo-people, this is mostly an IBO issue, I think, but
for
> > perhaps one more test I will keep it here, since it seems to have
been
> > thrown up by some DSQL change between RC2 and Release 1...
>
> Keep it here, keep it here!
> If the staments work in RC2 and not in 1.0, it's a Firebird issue,
and a
> big one.
> Perhaps thousands of (IBO) applications are now unable to work with
> Firebird.
> FWIW, I don't know what the point of qualifying field names in
insert is
> in the first place, but a quick look at the SQL specification says
it
> should be possible (or, better, I haven'f found where it says it
isn't
> allowed).
> Ciao
> --
> ____
> _/\/ando