I'm sorry, Mohammed.
I forgot so the last parameter must be empty string and I wrote "as" instead "alias" in first row.
use anytable in 0 alias anyalias
do main.prg with "anyalias","orcl","user","password",""
MartinJ
>hi,
>i try as under
>i get error message
>Command contains unrecognized phrase/keyword
>
>use mac1 in 0 as anyalias
>do main.prg with "anyalias","orcl","user","password"
>
>if i try as under no error message but where i can see th oracle table
>
>use mac1 in 0
>do main.prg with "anyalias","orcl","user","password"
>
>thanks
>
>>
DBF2Ora>>How to call:
>>
>>use anytable in 0 as anyalias
>>do main.prg with "anyalias","orcl","user","password"
>>
>>* if your tale contains any binnary fields (C/M NO cptrans), it's problem
>>*do main.prg with "anyalias","orcl","user","password","nocptfield1,nocptfield2,"
>>
>>
>>MartinJ
>>
>>>thank you for replay,
>>>i mean via vfp code,program..
>>>anyway thanks.
>>>
>>>>You can use REMOTE VIEW or SPT, it's similar way as for MySQL, MS Access, MS SQL etc.
>>>>I have asmall utility for upload tables from VFP to Oracle, but only data - no indexes.
>>>>
>>>>MartinJ
>>>>
>>>>>hi all,
>>>>>
>>>>>any idea,help
>>>>>is there a way to convert vfp.table to oracle.table
>>>>>
>>>>>thanks.