Prev: PDFCreator and VO
Next: pMySQLServer lib
From: bazman on 25 Mar 2007 12:18
I have a DataWindow with 2 bBrowsers using 2 different DBServers.
Everything works fine using "SetSelectiveRelation" except I would like
to display the records in the second bBrowser in a different order to
the "SetSelectiveRelation". I'd like to keep the 2 Servers in Sync no
matter which bBrowser Record changes.


eg Srv1->KeyID to Srv2->KeyID but show Srv2 in Srv2->Name Order.

Srv1 is a one to many in Srv2

Using CAVO26, bBrowser 1.4.

Thanks for any advice.

Nick Vlachou

From: Marc Verkade [Marti IT] on 25 Mar 2007 13:32
Hai,
For server 2 you need to create an order like 'KeyID+Name' and use that
order for the 3th parameter of the SetSelectiveRelation.
Ik will select all data from KeyID and sort them using the Name.
Regards, Marc

<bazman(a)arach.net.au> schreef in bericht
news:1174839492.530193.60790(a)l77g2000hsb.googlegroups.com...
>I have a DataWindow with 2 bBrowsers using 2 different DBServers.
> Everything works fine using "SetSelectiveRelation" except I would like
> to display the records in the second bBrowser in a different order to
> the "SetSelectiveRelation". I'd like to keep the 2 Servers in Sync no
> matter which bBrowser Record changes.
>
>
> eg Srv1->KeyID to Srv2->KeyID but show Srv2 in Srv2->Name Order.
>
> Srv1 is a one to many in Srv2
>
> Using CAVO26, bBrowser 1.4.
>
> Thanks for any advice.
>
> Nick Vlachou
>


From: Stephen Quinn on 25 Mar 2007 19:23
Nick

You do not have to set the order of the child to the same order as the master.
Eg
Srv1:SetOrder( '_KEYID' )
Srv2:SetOrder( '_NAME' )
oSrv1:SetSelectiveRelation( oSr2,{|| _FIELD->KeyID }, '_FIELD->KeyID' )

--
CYA
Steve


From: bazman on 26 Mar 2007 08:27
Thanks for the replies:

Resolved this way:

oSrv1:SetSelectiveRelation( oSr2, { || left(_FIELD->KeyID, 7 ) }, '
left ( _FIELD->KeyID, 7 ) ' )

So Stephens method worked fine after a few attempts.

The 2nd browser needed a particular ORDER and I achieved this by using
the LEFT function.

Thanks again
Nick


On Mar 26, 7:23 am, "Stephen Quinn" <stevej...(a)SPbigpond.netAM.au>
wrote:
> Nick
>
> You do not have to set the order of the child to the same order as the master.
> Eg
> Srv1:SetOrder( '_KEYID' )
> Srv2:SetOrder( '_NAME' )
> oSrv1:SetSelectiveRelation( oSr2,{|| _FIELD->KeyID }, '_FIELD->KeyID' )
>
> --
> CYA
> Steve


 | 
Pages: 1
Prev: PDFCreator and VO
Next: pMySQLServer lib