General information
Title:
Deleting records in updatable views
*-- 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
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