>>>>Im trying to create an updateable view in my project using the view designer..
>>>>I select the table from my DBC and select the fields.
>>>>I create an updateable view using the view disigner. I check on the "SEND UPDATE" CHECK BOX and check the fields to be updated. I check the Update using SQL Update and also SQL where Clause includes and I check Key and updateable fields. I then save the view. the problem im getting is as follows..
>>>>
>>>>When I try to browse the view and make changes then try to close the view I get the following error message.
>>>>
>>>>"No update tables are specified. Use the tables property of the cursor."
>>>>
>>>>can anybody give me any suggestions on why this is happening...
>>>>help will be greatly appreciated..
>>>>
>>>>Orlando Pagan
>>>>V.O.R. Technologies.
>>>>E-Mail: Orlando.Pagan@worldnet.att.net
>>>
>>>I had this too. Have you selected and checked off update fields in the Criterea section?
>>
>>Yes I have. but still doesnt want to update...
>
>Well, let's see...I've forgotten exactly what I did for that message, but try =Cursorsetprop('sendupdates',.T.), and =tableupdate().
>
>I also used some coded dbsetprops for tables, fields, and sendupdatess to get it to work, see Arnon's VFUG Tips page for some ideas on this.

Bruce,

Thank for the suggestions.. I will try that also..
After a couple of fustrating hours playing with the view designer, I realized that maybe the problem had to do with the DBC withing the project itself. So I removed all the tables from the DBC and then removed the DBC from the project itself. Next step I took was to create a brand new DBC and add the tables to it.. Once I added the tables I created the same view and ran it.. "BINGO" it worked.!!!!! I guess maybe the problem had to do with the DBC itself and how it was added to the project file..
Anyway.. wich way do you think is better to create an updatable view.. throught the view designer or programatically...??

Orlando