Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL View from view designer
Message
De
01/06/1998 18:13:36
 
 
À
28/05/1998 11:50:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00101710
Message ID:
00103808
Vues:
23
I am using a read only view for record navigation in a grid and bound controls are using the updatable view. Both views are parameterized. I requery the updatable view using the PK of the read only view like this;
>
>lcMst_PK=V_MASTERIDPARM.Mst_PK
>=requery(THISFORM.icMainViewAlias)
>
>So I should be able to requery the 'new read only' view in a similar manner eh? I'll have to give this a try and see what little framework grimlins await me.<s>

Excuse me, but I'm working on a very similar solution and I don't think that using two views would be a good idea. If I've understood it right you're using a read-only view with user-friendly fields for the foreign keys, and an updatable version (for the same main table) on a form. Right ?
If so, why don't you use a single updatable view for both the grid and the form ? You could set the grid as read-only, and leave the bound controls as they are, and you'd need to requery the view once for both modes. Wouldn't it be better ?? I understand that the use of the Join clause causes a certain loss of performance, but requerying the 'same' view twice isn't better at all...
Sincerely,

Andrea Brajuka
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform