I see now, Kevin.

In that case you'll need to use the DBSetProp() command to set the update properties for each field as well as to make the view as a whole updateable. It's a PITA to do.

GenDBC will give you the basic code to copy, however.

HTH
Barbara

>Barbara,
>
>Thats now what I mean. I need to be able to create an updatable
>view IN CODE, not in the view designer. I did it in the view
>designer so I could copy the SQL statement into my code. I DID
>set the update settings, and it works fine if I leave the view in
>the databasem, but I don't see in the resulting SQL any reference
>as to how this view is updatable.
>
>The reason for this is that I have many folders on the network,
>each for a client, and each has it's own database that is identical
>to all the others.
>
>I have a data procedures class that I use to update all tables for each
>client should I change a table structure or something else in the DBC.
>
>Each time I create a new client, or change the structure of the base table
>I don't want to have to go into each database and add the view, so I'm
>going to do it in my data procedures class.
>
>So far I can programmatically create the view, I just can seem to make
>a view that is updatable
>
>Thanks