Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update a table in a database with a view
Message
From
05/06/2007 03:44:56
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Update a table in a database with a view
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01230467
Message ID:
01230467
Views:
65
Hello,

I have a table in a database from which I make a view:

CREATE SQL VIEW view5 AS SELECT uniekid, name1 FROM table1

I make the field in the view updatable:

=DBSETPROP('view5.uniekid', 'Field', 'KeyField', .T.)
=DBSETPROP('view5.uniekid', 'Field', 'UpDatable', .F.)

=DBSETPROP('view5.name1', 'Field', 'UpDatable', .T.)

I change the inside of the field name1 in the view and then close the view,
but the inside value of field name1 is not changed...???

Can anybody help me out with this one? What am I doing wrong?

Thanks in advance
Ron
Next
Reply
Map
View

Click here to load this message in the networking platform