Valentina : CONVERT RDBLINK

Aldwin Pollefeyt realbasic at datalinesolutions.net
Wed Sep 8 17:21:41 CDT 2004


Is list.macserve.net the official mailinglist for Valentina???

I want to set the pointers after an importText() in an Valentina 
database.
Contact : 688 Records  Klanten: 896 Records
And I have to do this also for a BaseObject with 64.000 Records

Normaly: But this gives a crash !

   CONVERT RDBLINK Klanten.nummer=Contact.Klantnummer INTO Klant_Ptr

Things I tried:

Wrong result:
UPDATE Contact SET Klant_Ptr=(SELECT RecId FROM Klanten WHERE 
Klanten.Nummer=Contact.Klantnummer)
UPDATE Contact SET Klant_Ptr=Klanten.RecId JOIN Klanten ON 
Klanten.nummer=Contact.Klantnummer

Doesn't work at all(error in syntax):
UPDATE Contact JOIN Klanten ON Klanten.nummer=Contact.Klantnummer SET 
Klant_Ptr=Klanten.RecId
Err 607 : Expected '('  with VISql
UPDATE Contact,Klanten SET Contact.Klant_Ptr=Klanten.RecId WHERE 
Contact.Klantnummer=Klanten.Nummer
Err 607 : Expected '(' with VISql

Greetings,

aldwin



More information about the Valentina mailing list