Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EView quirck
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
EView quirck
Divers
Thread ID:
00296996
Message ID:
00296996
Vues:
75
The program below generates an example of a problem I had with eView: can't set TblC and all of it's fields to be updatable.

create database evt
create table TblA ;
( pkTblA i Primary Key )
create table TblB ;
( pkTblB i Primary Key, ;
fkTblA i references TblA )
create table TblC ;
( pkTblC i Primary Key, ;
fkTblB1 i references TblB, ;
fkTblB2 i references TblB )

create sql view lv_evt as ;
select pkTblA, ;
one.pkTblB, ;
tblc.*, ;
two.pkTblB ;
from TblA ;
join TblB one on pkTbla = one.fkTblA ;
join TblC on one.pkTblB = fkTblb1 ;
join TblB two on two.pkTblB = fkTblB2

DBSetProp("lv_evt", 'View', 'SendUpdates', .t.)
DBSetProp("lv_evt", 'View', 'Tables', 'Tblb')
DBSetProp("lv_evt", 'View', 'WhereType', 1)

DBSetProp("lv_evt.pkTblc", 'Field', 'KeyField', .T.)

use lv_evt
do \foxbin\eview

Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform