Need vfp Guru help.

[kueyiar]

I'm having trouble updating a table with a view. The view has a pk and all updatable fields set, as well as the send sql updates tick.
The thing is, that when a new record is added, and i issue a =tableupdate(.t.), the new record is added with no trouble, but when i use the view to modify any existing record and try =tableupdate(.t.), the update doesn't take place even though it doesn't report an error, and when i try a =requery(), 'sintax error' is displayed. If i issue a =tablerevet(.t.) then the record goes back to normal.
I'm not able to modify any given existing record with the view.
I really need the help !
Thanx

 

[ronald777]

hi,

I suggest u have checked with cursorgetprop('updatenamelist' ...'sendupdates... etc.) the condition of the view

 

[kueyiar]

i've checked it and everything seems to be ok, i really don't know what else to do ?

 

[mspratt]

Post your code. Perhaps someone will see the problem.

Regards,

Mike

 

[kueyiar]

I've noticed something strange:
I use views to update tables of vfp previous version 6,7; update, revert, append with my current 8.0 version and everything is fine, but if i try to do the same thing on a new table it will only allow me to append it new, not modify it. Does the function oldval() have anything to do with it !

 

[Mike Gagnon]

but if i try to do the same thing on a new table it will only allow me to append it new, not modify it. Does the function oldval() have anything to do with it !

You original question was about views. If you have a new question about table, please start a new thread.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[kueyiar]

It is about views, that is what i meant. If i use a view with a table already build on old version that already contains records i'm able to append and modifiy it, different case with the views i use with tables built on vfp8, does the function oldval() have anything to do with it !?