General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Arnon,
Thanks for your help, I have a master views dbc in another directory and every time the app starts it takes a fresh copy from this. I had set the local views file OK but forgot to set the master one.
Once again thanks.
Regards
Doug Johnston
>>I have a dbc defined containing all my tables, one of which is contacts.dbf. It contains a number of index tags one of which is idnum, C, 10.
>>
>>I also have a dbc containing views of all the files in the original dbc and one of the views is vContacts.
>>
>>I have a form which has a number of views in the data environment and one being vContacts which is filtered on lcBegNum (beginning IDNUM) and lcEndNum (ending IDNUM).
>>
>>Initially the form starts with lcBegNum and lcEndNum = '0000000001'. All works fine.
>>
>>If I add a new record, the view is updated correctly displaying all the field data as it should including the newly created IDNUM, however, when I TABLEUPDATE(.T.) the original contacts.dbf has every field updated except for IDNUM which remains blank.
>>
>>Can someone please shed some lite on this problem.
>
>Hello Doug
>check your settings (DBGETPROP) for this field and correct whatever is wrong
>specifically make sure Updateable is set to .T. and that UpdateName is mapped to the correct field (contacts.idnum)
>
>Arnon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only