>Hi,
>
>The command DBGETPROP(viewname,'View','Tables') is at the heart of one of the downloadable utilities in the files section - Findtbl.scx. I've learned that it returns only the names of the tables in a view whose fields have been set to updateable. Which leaves me clueless for those views that are for recordsources only. I've started setting the fields of included tables as being 'updateable' but not setting the 'send updates' flag so I can get the complete list of views for any table. My question is this: Is there any reason why I should not set the otherwise read-only views' fields as updateable?
>
>There's nothing in Hacker's Guide or in the programmers guide concerning this.
>
>Thanks in Advance,
Actually, I find it better to only use views for updateable data. Anything I don't plan to update I just use a select statement to a cursor or SQL Passthrough. For ease of modification, all data access in our app goes through a standard data access object which handles updates and logs all data changes to our transaction log file.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc