Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with local view and tableupdate(.t.)
Message
From
24/02/1999 03:56:05
 
 
To
24/02/1999 03:22:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00190823
Message ID:
00190832
Views:
12
>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
Next
Reply
Map
View

Click here to load this message in the networking platform