Hi Graeme,
<i><font color="#663300">CURSORSETPROP("Sendupdates", .T.)</font></i>
You need to use DBSETPROP() to set all those properties in the database for the view.
If you create a view in the view designer for just the table whose fields you want to update, you can use Gendbc (Home() + " oolsgendbcgendbc.prg") to generate the necessary code with all the DBSETPROP() statements. You can then cut-and-paste that code into a program file and modify the SELECT statement to join in the other tables that you need.
:-) Pamela pamela (at) eagle-crest DO.T com ©2001 Pamela Thalacker |