Method Field Question

[Karl Grob]

Hi Ruslan

I understand. It is impossible to do what I wanted in this way.

What do I want?
Think of a bundle of pages of a manuscript and its representation in picture and text. You have the sheet (tblBlaetter) that has 2 sides (recto, verso: tblSeiten) and on every side, you have different frames as e.g. in Indesign (tblRahmen) to present a text in its original form (corrections, turned around etc.). Within this structure you have although tblWords etc. If you want to find out on the screen where you are under every letter (cursor position=manuscript, page etc.) you must have all this information together in a very quick way (= in one Cursor - Client-Server!). This was my idea, but real ObjPtr-Links are of course although possible. 
I have to mix between using links and search-routines. The ObjPtrs give me the correct RecIds of the far away Parents and the database guarantees the consistency.

Thanks and best regards
Karl

BTW: You can see a first version (without Faksimiles) if you download the Client from www.eHKKA.ch. It works with about 3’500’000 Words in a similar structure - not yet as fine as necessary for facsimiles.

Am 11.07.2014 um 23:03 schrieb Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>:

> On 7/11/14, 11:46 AM, "Karl Grob" <kgrob at mus.ch> wrote:
> 
> Hi Karl,
> 
>> I have a hierarchical tree of 3 tables: tblBlaetter, tblSeiten, tblRahmen
>> (always 1:m from left to right).
>> I use ObjPtr-Fields to establish the parent-child-Structure.
>> 
>> In ValentinaStudio I make the SQL-statement:
>> 
>> 'SELECT ptrBlaetter FROM tblSeiten, tblRahmen WHERE tblSeiten.RecID =
>> tblRahmen.ptrSeiten‘.
>> 
>> This gives me a correct result.
>> 
>> If I define in tblRahmen a ULong-MethodField ‚copyPtrBlaetter‘  with the above
>> method, this field does not work. Of course I could make real Links, but as
>> the thing is strictly hierarchical, I could not really use them. I just need
>> the information of the whole hierarchy above the table in question.
>> 
>> Why doesnt this work or what am I blind for?
> 
> 1) Method of Table can use only fields of THIS table.
>    it seems you try something else
> 
> 2) Method contains  EXPR rule, but not the whole SELECT.
>       SELECT expr1, expr2, expr3 ... FROM T ...
> 
> 
> 3) I do not see what you want and why?
>        you want to have in T3 pointer to T1 ?
> 
> 
> You can use then METHOD
>    tblRahmen.ptrBlaetter
> 
> With formula:
>    ptrBlaetter.ptrBlaetter->ptrBlaetter
> 
> Here is used  operator ->
> 
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1394 bytes
Desc: not available
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140712/222780ab/attachment.bin>