Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL View from view designer
Message
From
01/06/1998 18:13:36
 
 
To
28/05/1998 11:50:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00101710
Message ID:
00103808
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform