Transfering varchar2 field data to blob data.

[heuserj]

I am working on converting an Access 97 application to Delphi.

The back end is Oracle 8.17 Enterprise edition.

I want to transfer data that is presently in a varchar2(2000) data field to a blob field so that I can take advantage of RTF edit controls. There are presently to varchar2(2000) fields in one table that I am interested in updating. My questions are:

1. Can one have 2 or more blob fields in 1 table?

2. After the blob fields are added to table, whatis the easiest way to transfer data?

Thanks for your help

John

 

[Marco Kalter]

1. Can one have 2 or more blob fields in 1 table?

Yes, though you should use a CLOB column for character data.

2. After the blob fields are added to table, whatis the easiest way to transfer data?

update

set = ,
=

------------------
Marco Kalter
Allround Automations

 

[heuserj]

Tahnk you very much