Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() on local view fails after editing memo fie
Message
From
26/01/2000 22:34:41
 
 
To
26/01/2000 20:11:04
Scott Knight
Human Resources Development Canada
St. John's, Newfoundland, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00323294
Message ID:
00323358
Views:
21
>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...
>

Does TABLEUPDATE() return .F.? If so what's in AERROR()?

What is your view's UPDATE WITH setting? (Key fields, key and modified fields, etc)
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform