>Hi, I'm very new to FoxPro and I'm having some problems accessing a remote view. I'm running FoxPro 5.0. I need to append data from a temp table called tempweb to the remote view which is connected to Oracle.
>
>My code:
>use vwhe_card
>append from c:\tempweb
>
>However, I get that foxpro is unable to locate vwhe_card.dbf. Is there something I have to do differently b/c it's a remote view? A side question is: "Does the temp table have to be set up exactly like the oracle table to have the fields placed correctly?" I would really appreciate any and all help.
>
>Thanks again,
>Sunshine
Make sure the database (DBC) where the remote view is stored is open before you try to use the view:

open database YourDBCGoesHere  && <----
use vwhe_card
append from c:\tempweb