Valentina : CONVERT RDBLINK

[Ruslan Zasukhin]

On 9/8/04 6:21 PM, "Aldwin Pollefeyt" <realbasic at datalinesolutions.net>
wrote:

> 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

Klant_Ptr -- this is objectPtr, right?

You have create it self AFTER import ?


> 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

I do not understand why you talk here about UPDATE ?


-- 
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
-------------------------------------------------------------