Re: [SQL] Request into several DBMS simultaneously on DDL and DML

2007-09-03 Thread Dmitry Turin
DT> As result, __new type of system information__ appears: DT> field, refering to other field by foreign key, DT> has additional bit except own value - DT> bit specifies, whether record, to which it refers, DT> is in the same or in other database. DT> It's necessary to not signalize about break of

Re: [SQL] Request into several DBMS simultaneously on DDL and DML

2007-09-01 Thread Dmitry Turin
Good day, Richard. DT> As result, __new type of system information__ appears: As result, new type of system information appears - field, refering to other field by foreign key, indeed contain two values: (1) usual value, assinged into field by user select FieldFK, ... insert

Re: [SQL] Request into several DBMS simultaneously on DDL and DML

2007-08-28 Thread Richard Huxton
Kitter Georgiy wrote: (1)Let's allow to __connect into several DBMS__ at once, last of them becomes DBMS 'by default'. ... It's necessary to not signalize about break of foreign key, if remote database will not connected in next time. But that's the vital bit. Without being able to extend rel

[SQL] Request into several DBMS simultaneously on DDL and DML

2007-08-27 Thread Kitter Georgiy
(1)Let's allow to __connect into several DBMS__ at once, last of them becomes DBMS 'by default'. User assign any nickname to each database at connection, except nickname 'all' and 'local', e.g. connect ra=database.remote.com username=Smith password=pwds nickname=db1; connect ra=db.distination