Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View Caused Syntax Error
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement