Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records in updatable views
Message
From
15/04/1998 10:08:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Deleting records in updatable views
Miscellaneous
Thread ID:
00092139
Message ID:
00092139
Views:
54
*-- Why the given below code works incorrectly and how it to correct?
*-- I shall be glad to any advice
CREATE DATABASE My_dbc
CREATE TABLE My_table (pk c(8) PRIMARY KEY, fld c(10))
INSERT INTO My_table (pk,fld) VALUES ('00001','First Rec')
CREATE SQL VIEW My_view AS SELECT * FROM My_table
DBSETPROP('My_view','VIEW','SendUpdates',.T.)
USE My_view
DELETE
GOTO (RECNO())
RECALL
GOTO (RECNO()) && I get message "Uniqueness of index PK is violated"
Next
Reply
Map
View

Click here to load this message in the networking platform