Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set DynamicBackColor by Group
Message
From
10/04/2005 09:39:39
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01003119
Message ID:
01003196
Views:
19
>Dragan,
>
>Thanks, but what if I'm using Views to populate my grid. I can't use ALTER TABLE on a View. Will I have to add a Formula field on something to my Views (over 20 of them). I''d like to be able to get the result without having to alter the View. (I have a couple of instances where it MAY be a cursor, but mostly Views.)
>
>Thanks

If the view isn't updatable (at least not from the grid), you can create a cursor with the same fields as the view, plus this one field, and then zap it and append from dbf("viewalias") whenever you need to populate the grid, and then do the above trick on this cursor.

If the views are updated from within the grid, then this is a problem. You may do some scheme to post updates from the cursor back into the view, but I think it's not worth the trouble, and you're actually losing some of the control over validation etc. You may still create a separate cursor like Fabio said, with this column there, and have a relation from your view into this cursor. That would work.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform