>dirinler wrote:
>>
>> 2-i wantto connect two fdbs in the same project.i also wantto copy a
>> row from 1.fdb to 2.fdb is this possible?

Not in any current release. You need a multi-database transaction (with one connection each for fdb1 and fdb2), where you have one SQL object (based on a SELECT statement) to select the row from fdb1 and another (an update or insert statement) to write its data to a row in table in fdb2. Since you're using Delphi, there are components available that wrap this kind of operation, e.g. the TIB_Datapump component of IBObjects.

However it will be possible to do it in Firebird 2.5, using an EXECUTE STATEMENT call in a PSQL module (stored procedure, trigger or EXECUTE BLOCK construct.)

>and can i use them as master-> detail fdbs?

Do you mean master-> detail relationships? Unfortunately not in 2.5, perhaps in v.3.0, for which there has been strong talk of implementing schema namespaces.

./heLen