Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying data on second monitor
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01686274
Message ID:
01686280
Views:
49
For 2nd monitor -- use VFP ODBC driver & create a REMOTE view to the table - then use time-event and and requery() the remote view.

If you don't want to use the timer then create triggers on the table (for insert, update, and delete delete) to run stored procedure that requerys the remote view. Seems like you still might need a timer though to refresh a grid or something on 2nd screen depending upon what it is you're trying to do.

Edit: You could put the refresh() in the stored procedure too I guess.

>You described exactly my current solution but I'm looking for something nicer. I wanted solution with view and requery but view open original table as exclusive :-(
>
>>>I have a local table which is open exclusive. INSERT, DELETE, ZAP is used on that table.
>>>Any ideas how to display those data on second monitor on a fly with all changes applied? I prefer another program which is displaying on a second monitor (extend monitor).
>>
>>How about something that would be just one form with a timer firing its .refresh(), and there you requery your cursors, pulling from this table?
>>Though, not sure it would be possible if it's open exclusively, perhaps trying to open it readonly in this second app. If it won't allow you even so, then export from the first app periodically and then select from this exported table in the second.
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform