>>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,

I had checked the aerror and it showed nothing, getfldstate showed as being modified. This morning when I tried to run the app again I got an error message something like thisformset or one of its memebers record 21 ... Insufficent stack space. I had made no changes to app so I new it was something external to the code. I tried to modify the view through the database designer and got the same error message (I think it was error 2005) the view then opened except the table was gone making it empty. I then added the fields back, set the up criteria as I have done numerous times before and it seems to work perfect. I tried removing another view and re-creating it for a second table I was having the same problem with and sure enough it works perfect. I am 99.99 percent sure the view is set up with the same properties as before removing it. (it's a very simple view ). Strange...

Thanks again


Scott