<i><font color="#663300"><I><FONT COLOR="#663300">When I browse my local view from the command window and modify one of the fields and then issue a tableupdate, it always returns false. Then if I try to close it or move the record pointer, I start getting syntax errors until I do a tablerevert. The view is based on a single table with all the fields selected. The update tab has all the fields checked for update, as well as the key field. "Send SQL Updates", "Key and Modified", and update using "SQL Update" is checked. Using AERROR to get the error message only shows a 'Syntax Error'. I don't know of any stored procedures, field level rules, or triggers that are firing. I have tried re-creating the view, and even tried re-creating the table. I still cannot update my view. </FONT></I>
Hi Steve,
Three points.
1) If you have table buffering on for your view, change several rows, then don't send the AllRows parameter as .T. in your tableupdate, only the current row gets updated and you;ll get errors later.
2) I've had trouble with updating views with large numbers of fields - the SQL update statement than VFP generates internally gets too long. I don't see how that can be happening for you though - there aren't many fields.
3) Can you export your view as code and post it? Often the SETPROP commands which come after the CREATE SQL VIEW... are the ones than cause the trouble. I sometimes end up taking the view definition in code, commenting out all the SETPROP commands, then adding them back in one by one till I get the problem behaviour again.
Kevin
</font></i>
is there any escape sequence you can do to work around this same problem if for instance there is no way you can change the name of your feilds at this point
©2001 Dennis Golovaty |
