>Hi all,
>
>Is possible to create a view that holds a variable condition?
>
>This is for not creating a bunch of view each one with different conditions.
>
>The cool would be any similar to:
>
>CREATE SQL VIEW ... WHERE &mycondition
>
>And inside mi programs doing:
>
>mycondition = "totalsales > 500000"
>
>in another:
>
>mycondition > "state ='FL'"
>
>and so.
>
>Thanks,
Hi Pablo.
If not create a view?
Ex:
lcCondition = [ TotalSales > 500000 ]
lcCommand = [ SELECT * FROM MyTable WHERE ] + lcCondition
&lcCommand
¿Esto no es lo que quieres, verdad?
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________