Thanks Gary! I was placing the view name in cSource rather than the SQL statement.
Do you make frequent use of this type of cursor. It seems like the most flexible both from querying and upsizing?
Mike
>>Has anyone made use of this .ctype cursor?
>
>LSQLPT is the type.
>
>>I notice that the builder doesn't ask for an .csource property, but it still needs one.
>
>That is your local SQL query.
>
>>Also, I'm having dificulty getting the .cWhere and Requery to work.
>
>Just specify your normal WHERE filter of the SQL select statement but don't specify the WHERE clause itself. So, if you want to say :-
>
>
>SELECT * FROM Employees WHERE nEmpId = ?pnEmpId
>
>cSource = "SELECT * FROM Employees"
>cWhere = "nEmpId = ?pnEmpId"
>
>
>Just type the values I have specified above (replace with your own) in the cSource and cWhere boxes in the builder or in the property sheet. Obviously, if you type them in the builder/property sheet, you don't need the quotation marks.
>
>HTH