>I am trying to create a remote parametrized view and having some problems. The remote is via a connection to a paradox database.
>The view is created but no records are pulled, even those that match the parameter. Using VFP 3.0b Any ideas? Have tried trimming the statement, using like instead of equal, nothing works. HELP?
>
>syntax:
>
>CREATE SQL VIEW test1 CONNECTION medisoft AS SELECT * FROM mwpat WHERE mwpat.chart_number = ?ptrx
>
>ptrx=search parameter
>mwpat=paradox table name
>medisoft=connection name
>
>TIA
Did you identify the type of ptrx. (Query,View Parameters)