Another way is to issue a REQUERY( "TableAlias" )
P.J.
toggle quoted message
Show quoted text
-----Original Message-----
From: PJ Fernandez [mailto:pjfern@...]
Sent: Saturday, March 06, 2004 10:10 AM
To: madfox_vfp@...
Subject: RE: [madfox_vfp] remote views 101
The SQL View is a snap-shot of your data. Your control, (listbox, combobox,
grid), has to requery the data to get the latest information from disk.
Issue a MyForm.MyCOntrol.Requery() and this will get the latest data.
P.J.
-----Original Message-----
From: phecht_98 [mailto:phecht@...]
Sent: Friday, March 05, 2004 1:35 PM
To: madfox_vfp@...
Subject: [madfox_vfp] remote views 101
Hello,
I am working vfp6. I am attempting to have a remote view that links
to a sql server 2000 database.
I have the cursor and it works ok. But when I go to the other
application and change the data I don't see it! So, I have to close
data and use the view again. It seems I should be able to have VFP
update the cursor at a regular basis. At this time, it is a read
only app.
Soon, I will have to have read write access.
Peter
Yahoo! Groups Links
Yahoo! Groups Links