Yuck! I am not sure if this would work or if you could even updata data this way, but you could create a linked view in MS Access, then create a RV in VFP to the MS Access view. Blasphemy! < g >
>Tried the MS Oracle drivers. It says I have no "client software." Downloading Personal Oralce for the heck of it. Good thing I have a high-speed line and a big hard drive. ;-) I don't think using MS drivers will get me anywhere. It's like hoping they speak Portugese in Spain because they're both in Iberia.
>
>Again, this product was originally developed by Digital Equipemnt. It doesn't use PL/SQL for example.
>
>In any case, the syntax I'm using to test is "SELECT * FROM Locations" where Locations is a nice little 20 record file. I've also used "SELECT Location, Title, Active_flag FROM Locations" with similar bad luck. Definitely not complicated syntax!
Mark McCasland
Midlothian, TX USA