General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate() on local view fails after editing memo field
I am having some problems when trying a tableupdate() a local view after editing a memo field. Some background...The local view selects all the fields,has all fields marked as updateable, send updates is checked, the required keys are set O.k. I have optimestic table buffering set on the view and no buffering set on the table. I can edit any other field except a memo field and the tableupdate works o.k and the data is written to the table as planned. If I edit the memo field and Tableupdate() it fails. The strange thing is on an add it works perfect. I had a glitch earlier where one of the field names was "group", I assume because it is keyword in SQL a syntax error was created. The field name in this case is empdesc. I also tested this from the command prompt using the view, setting the cursorprop, modifying the data through a browse and I got the same results. As long as I did not edit a memo field everthing was O.K. and the tableupdate would work ???
Any insight would be greatly appreciated...
Thanks
Scott K
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only