Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to store files on Oracle ?
Message
From
09/01/2001 09:12:00
 
 
To
09/01/2001 08:17:50
General information
Forum:
Oracle
Category:
Other
Miscellaneous
Thread ID:
00461082
Message ID:
00461096
Views:
14
Howdy,

You can use long raw but you may only have one column of
this type per table. Or you can use blob or clob. (These allow you to have more than one per table but you can only use the oracle odbc driver.)

Either one your choose the rest of what I am saying goes....
You can do
SQLEXEC('select * from mytable','mytable')
Then you have a vfp cursor...
You could put the file in with
append general c:\myfile .....
If you browse and have a look you will see your file...

Then to update or insert use....

SQLEXEC('insert into mytable values(?mytable.general_field)','mytable')

Or use remote views...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform