>Hi all
>
>Help please
>
>I have 'remote view' inside my dbc for to retrieve filtered data from Microsoft Access tables ('view' code - following).
>When I run this view, VFP ask for 'view parameter', take my input and running well.
>
>But how can I use with this in my project (openning it in form without 'view parameter' message and update my as per VFP veriable)?
>
>The 'View' code:
>SELECT Data.ImageId, Data.Coments, Data.Kit, Data.Date, Data.Field2,;
> Data.Nomber, Pictures.ID, Pictures.Image;
> FROM ;
> Data Data ;
> INNER JOIN pictures Pictures ;
> ON INT(VAL(Data.imageid)) = Pictures.ID;
> WHERE Data.Nomber LIKE ( ?cnomber )
Hi Chaim,
You can open such a "parameterized" view with the "NoData" clause if you use the Use command. Or set .NoDataOnLoad=.T. if it is a in a form.DataEnvironment:
Use theView NoData In 0
Local cnomber
cnomber = '%99%'
Requery('theView')
hth
-Stefan