>I would like to move an app from 2.6 to VFP5. Basically the app searches on field information and displays the results. One field is a 60 character description field. A person may want to search for "MAIN STREET" and then visually scan the results for the exact record desired. The 2.6 version uses a sql select and a cursor to display the results in a browse. I would like to use a parameterized view in VFP to do the same.
>
>Is it possible to use something like:
>
>SELECT * ;
> FROM SHAREDWO ;
> WHERE cDescription $ SHAREDWO.DESCRIPT
>
>where cDescription is a passed parameter? I'm not having much success.
cdescription = 'TEST'
CREATE SQL VIEW TEST AS;
Select *;
FROM sharedwo;
WHERE ?cdescription $ sharedwo.descript
HTH
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown