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