API methods on binary link

Olivier vidal_olivier at yahoo.fr
Sat Jan 22 13:03:03 CST 2005


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'

How to make easily the same thing with the API?

thank you

olivier




More information about the Valentina-beta mailing list