Table update

[prakashroch]

I am collecting some real time process data from a manufacturing application into Sybase. I have a table in FoxPro whose source the Sybase table. The Sybase table is supplying values ever 2sec to FoxPro. In order to see the latest values in FoxPro I have to close the FoxPro application and reopen it. Is there any other way to see the values without closing the FoxPro Database?
If this is possible then my next question is:
Is it possible to have a program continually running in FoxPro that checks for a particular value in the table and accordingly and pops up some message?
Thanks

 

[ramani]

HI
There is no need to close the application and run it again.
You can use a DO WHILE .T. loop to trap the data and display continuously or do what ever you want. But remember to insert a trap to exit the loop as well.. That trap could be pressing an ESC key for example. So ON ESCAPE you can do an exit from within the loop and end your programme. Or you can use an ON KEY LABEL..
.. Example..

DO WHILE .T.
** DO MY JOB
** DISPLAY MY FRESH VALUE
** WHATEVER
IF LASTKEY() = 27
EXIT
ENDIF
ENDDO

Hope this helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com