SQL and API methods + benchs

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Jan 24 10:06:32 CST 2005


On 1/24/05 7:44 AM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

> Some remarks: 
> 
> I have a crash if I use:
> SELECT zipcode, cityname, namestreet FROM zipcity, street where zipcode =
> '75000' 
> 
> With 
> SELECT zipcode, cityname, namestreet FROM zipcity join street on
> linkCityStreet where zipcode = '75000'
> That works perfectly.

Oliver, have you specify FOREIGN KEY for this tables?
Or you use ObjectPtrs?
Or BinaryLink?

Please send to us DB and we will try the first query in the viSQL
To fix crash. CC db to Ivan.


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




More information about the Valentina-beta mailing list