CONVERT RDBLINK crashing

[Ruslan Zasukhin]

on 11/12/03 1:26 PM, Peter De Berdt at peter.de.berdt at pandora.be wrote:

Hi Peter,

> Using RB 5.2.1, MacOS 10.2.8
> 
> I'm having trouble migrating an Interbase export (tab-delimited) to Valentina.
> 
> I have been able to import the records, no problem here. There are
> ten tables that are imported, some of them have 10,000+ records (the
> largest table has 69,000 records, all importing at decent speed).
> 
> I also created ObjectPtr Fields defining relations between the
> tables. All of these are set to 0 as they ain't defined when
> importing.
> 
> After importing all files, I used the following SQL command in order
> to convert the Interbase related fields to Valentina's ObjectPtrs:
> 
> res=myDB.SQLExecute("CONVERT RDBLINK Contacts.CustomerID=Customers.ID
> INTO Contacts.Customer_Ptr")
> 
> Three records are processed, then the application crashes, no RB
> error, no Valentina error. This happens on all three platforms (MacOS
> X, MacOS 9 and Windows).

Well, then you can 

1) import in 2 related tables only e.g. 1000 records only.
   this give us small enough db

2) try RDB CONERT on this db
    crashes?

    then please send me this database and SQL query.
    I will test it from viSQL.


> I tried to link other tables (in case there was an error in the
> Customers<->Contacts relation), but all attempts resulted in a crash).
> 
> I must add the fields coming from Interbase that relate are in fact
> VarChars and not Unsigned Longs, but they do match. So, I'm using
> CONVERT RDBLINK between two VarChar fields (identical length and
> structure).
> 
> Any clue as to why this crashes?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------