Greetings.
I've created a view using the following code. The problem I'm having is sometimes the view wouldn't update the parent table even thought I use the following command =TableUpdate(0,.T.,"SelectedFiles") whenever I need to update the parent table.
Any help to solve this problem will greatly appreciated.
Thanks
Carl
Function CreateView
Parameter lcWhere, lcOrder
Set Safety Off
Create SQL View SelectedFiles As;
Select All *;
From "File Manager!Files";
&lcWhere;
&lcOrder
Set Safety On
*Set the View as updatable
*
*Match the view fields to thier parent table counterparts....only for those fields that's updatable
=DBSetProp("SelectedFiles.Type", "Field", "UpdateName", "Files.Type")
=DBSetProp("SelectedFiles.Reminder", "Field", "UpdateName", "Files.Reminder")
=DBSetProp("SelectedFiles.Notes", "Field", "UpdateName", "Files.Notes")
=DBSetProp("SelectedFiles.User", "Field", "UpdateName", "Files.User")
*Set which fields are updatable
=DBSetProp("SelectedFiles.Type", "Field", "Updatable", .T.)
=DBSetProp("SelectedFiles.Reminder", "Field", "Updatable", .T.)
=DBSetProp("SelectedFiles.Notes", "Field", "Updatable", .T.)
=DBSetProp("SelectedFiles.User", "Field", "Updatable", .T.)
*Set the keys that will be used to determine which record would be updated in the parent table
=DBSetProp("SelectedFiles.Dir", "Field", "KeyField", .T.)
=DBSetProp("SelectedFiles.FileName", "Field", "KeyField", .T.)
*Set the Update function on
=DBSetProp("SelectedFiles", "View", "SendUpdates", .T.)
Carl