[Kexi] Tieing databases together?

[Jarosław Staniek]

scott said the following, On 2007-11-13 00:42:
> Jarosław Staniek wrote:
>> scott said the following, On 2007-11-13 00:17:
>>  
>>> Jarosław Staniek wrote:
>>>    
>>>> scott said the following, On 2007-11-12 23:43:
>>>>  
>>>>      
>>>>>    How does one define relationships between databases?
>>>>>             
>>>> Hello Scott,
>>>> If you mean tables, currently you can only define weak relationhips 
>>>> within queries. Physical relationhips within the database is not yet 
>>>> available and won't be until Kexi 2.x (x>0). You can always define 
>>>> them using external tools (if your engine is PotgreSQL or MySQL), 
>>>> but you need to know what are you doing.
>>>>
>>>> Relationhips between databases is also not supported, and won't be 
>>>> unless attaching a database is implemented (SQLite allows for this).
>>>>
>>>> Your other questions will be hopefully answered tomorrow.
>>>>
>>>>         
>>>   Thanks for the reply.  When might 2.0 or 2.x be out?  I am using 
>>> MySQL. Hopefully when altering a database when it has data in it 
>>> won't cause data loss in the next release.     
>>
>> You need to wait about 8 months for production stability. But in the 
>> meantime it is good idea to put as much as possible (sane) wishes or 
>> notes to bugs.kde.org about features that could be improved after 
>> transition to 2.x. Namely, you can be part of the Team.
>>
>>  
>>> Are you saying that with this release one can't attach a database?
>>>     
>>
>> By attaching I mean semantics like this: 
>> http://www.sqlite.org/lang_attach.html
>>
>>   
>  By the way, I tried importing the sample/test databases but it failed.  
> Might be a problem on my part.  If I get further information, is it 
> desired?

If these are sqlite databases not created in Kexi, you cannot import them 
using a simple GUI, unless you create system tables on your own, see 4.2 here:
http://kexi-project.org/wiki/wikiview/index.php?KexiFAQ#4._Database_Support_&_Data_Migration

You could send me example database (not to the list).

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org