Problem with CONVERT RDBLINK

[Ruslan Zasukhin]

On 9/9/04 12:52 PM, "Aldwin Pollefeyt" <realbasic at datalinesolutions.net>
wrote:

Hi Aldwin, 
 
> Hello, here is the little test project.
> 
> The import happens in wImport.doImportPrintPlus.
> 
> Thank you very much for helping me out.

You have 

testSQL=app.PPDB.SQLExecute(
    "CONVERT RDBLINK Klanten.nummer=Contact.Klantnummer INTO Klant_Ptr")

So as I see you have

                    Klanten.ID = Contact.PTR


But in Valentina SQL pdf is written

    CONVERT RDBLINK tableB.Ptr = TableA.Key INTO [tableB.]ObjectPtr
                   ^^^^^^^^^^^^^^^^^^^^^^

> NOTES:
> 1) Ptr and ObjectPtr fields MUST be in the same tables of course.
> 2) Order tableB.Ptr = TableA.Key is important.
> Reverse order, KEY, Ptr will not work.

Note point 2.

So to make it work you need change order

testSQL=app.PPDB.SQLExecute(
    "CONVERT RDBLINK Contact.Klantnummer = Klanten.nummer INTO Klant_Ptr")


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