>Sounds like, in your case, you are best served with remote views of the Oracle data and, therefore, you can process queries with VFP commands. By setting the view/field updateable properties you can pass data back to Oracle. Look out for Oracle columns with sequence constraints, though, don't try to update those.
>
>
>>I have an ORACLE server. I want to create a table in ORACLE with the structure of the table I have for a Foxpro table.
>>
>>I am using string concateanations and some progeam logic to create a query and then pass it to the SQL Plus by issuing command SQLEXEC.
>>
>>Is there a better way of doing it ?
>>And a way of updating table in ORACLE with FOX data.
>>
>>Like you create remote views of ORACLE data on FOxpro.
>>I DON'T WANT the ORACLE UPSIZING WIZARD.


Initially I don't have data or not even tables in the ORACLE Server.
First I have to CREATE A TABLE IN ORACLE SERVER.
and then try to update from fox to Oracle and then the process of getting data from Oracle to Fox comes.
and this continues.