Hi All,
I have a simple 1 parameter view which represents all fields from one simple table with one field as a Primary key.
I realized in my app that whenever a user change data on a grid with this view's data source I am getting "Syntax Error".
I tried to browse the view providing the correct key parameter in the IDE and it looks good (the first time), But, the minute I am changing one of the fields in the view and close it, whatever I am doing later to try to browse it or even getting out of VFP (IDE) I am getting "Syntax Error" message and don't know from where.
Here is the SQL statement for the view (the table Primary key is "KeyId").
SELECT *;
FROM jc!jcpocodt;
WHERE Jcpocodt.keyid = ?VHeaderKey;
ORDER BY Jcpocodt.costcode

In the view's Update Criteria tab all the fields are checked (the key is "keyid') and the "Send SQL Updates" "key Fields" and "SQL Update" are checked.

Any Ideas why?
TIA

shlomo