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