Orlando,

The unique way I found to be sure I fully understood what the view designer is doing is run the HOME() +"tools\gendbc\gendbc.prg" against my databases. Check the code of your view in the generated prg. You'll more than certainly learn from where the problem comes from.

Also, check the DBSETPROP command in help, it does a bunch of things.

José



>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