Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting records in updatable views
Message
From
15/04/1998 12:53:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
15/04/1998 10:08:31
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00092139
Message ID:
00092191
Views:
23
>*-- 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"
Set buffering on :
cursorSETPROP('buffering',5,'My_view')
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform