General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hello,
>
>I would like some ideas how to upload the Foxpro table to Oracle Unix
>table from the connection methodogy to the conversion field by field.
>
>FOXTABLE.DBF (Source table) to ORACLETABLE.ORA (Target table)
>NAME CHAR(20) NAME CHAR(20)
>
>Any source codes samples would be really appreciated !!!
>
>Thanks in advance,
>Paul
Here is some code that updates an Oracle table(cur_sys_inv) from two VFP tables(inventory.dbf and username.dbf)
UPDATE cur_sys_inv;
SET sys_status = ALLTRIM(inventory.status),;
cinv_time_stamp = inventory.timesent,;
current_location = ALLTRIM(inventory.location),;
current_site = username.site_name;
WHERE ALLTRIM(cur_sys_inv.ew_serno) = ALLTRIM(inventory.serialno);
AND ALLTRIM(cur_sys_inv.ew_mds) = ALLTRIM(inventory.mds)
If this is not what you are looking for I may have something else that will help.
Sammie
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only