Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting records in updatable views
Message
De
15/04/1998 12:53:28
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
15/04/1998 10:08:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00092139
Message ID:
00092191
Vues:
24
>*-- 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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform