API methods on binary link

[Ruslan Zasukhin]

On 1/22/05 2:03 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

> Hi Ruslan and list,
> 
>> I have a table of ZIP-Citys :
>> 
>>   zip=new vstring("zip",5,EVflag.fIndexed)
>>   city=new vvarChar("city",100,EVflag.fIndexed+EVflag.findexByWords)
>>   CityIdx=new vvarChar("cityIdx",100,EVflag.fIndexed,"city")
>> 
>> and a table of streets :
>> 
>>   street=new 
>> vvarChar("street",100,EVflag.fIndexed+EVflag.fIndexByWords)
>>   streetIdx=new vvarChar("streetIdx",25,EVflag.findexed,"street")
>> 
>> Every street belongs to a couple zip / city :
>> 
>> link_Street_ZipCity=new vbinaryLink("link_Street_ZipCity", ZipCityTb,
>> StreetTb, EVlinkType.kOne, EVlinkType.kMany)
>> 
>> 
> 
> If I want to see all the streets the zip of which begins with '33', in
> SQL I makes:
> 
> SELECT * FROM ZIPCity, Streets WHERE left(zip,2)='33'

You make at first search in table ZIP

    set1 = fldZip.Find( 33 )

Now you can iterate set and use

    Link.FindLinked(
        inRecID as Integer, inTableA as VTable, inTableB as VTable


Hmm, we need enable into V4RB one more function that do

    set = Link.FindLinked( inSet, TA, TB )

We have such func in kernel.


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