Request SQL

[Ruslan Zasukhin]

On 7/6/04 4:46 AM, "Thierry Nauze" <huancaya at wanadoo.fr> wrote:

Hi Thierry,

> Whith :
> boRelations
> name = "relations"
>  id = new vUMedium("id",kV_Unique)
>  idIndividu = new vUMedium("idIndividu")
>  idRelation = new vUMedium("idRelation")
> 
>  autoRelation=new vUMedium("autorelation")
>  autoRelation.setMethod("idIndividu-idRelation")
> 
> My request :
> "SELECT id,idSource,idIndividu FROM relations WHERE id>0 AND
> autorelation=0"
> works
> 
> 
> But,
> 
> boRelations
> name = "relations"
>  id = new vUMedium("id",kV_Unique)
>  idIndividu = new vUMedium("idIndividu")
>  idRelation = new vUMedium("idRelation")
> 
>  autoRelation=new vBoolean("autorelation")
>  autoRelation.setMethod("idIndividu=idRelation")
> 
> And the request :
> "SELECT id,idSource,idIndividu FROM relations WHERE id>0 AND
> autorelation*"
> don't works
> 
> autoRelation, autoRelation=true ...   Many expression were tried.
> What is then cood ?

What you mean with many expressions?


May happens that problem in Medium field.
Please try the same with ULONG field.


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