Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to store files on Oracle ?
Message
De
09/01/2001 09:12:00
 
 
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00461082
Message ID:
00461096
Vues:
16
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...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform