select raw data

[eledoa]

Hi there,

I have a special problem here. We have a table defined as

create table TAB_FILINH
(
FILINF_ID NUMBER not null,
REIHENFOLGE NUMBER(6) not null,
ZEILE RAW(255)
)

We store binary files in this table. In order to retrieve these files we have to select on or more rows out it and concat this rows to one binray string which is then stored in file system.

Perhpas I am missing something but I found now way to retrieve data out of a raw column. Do you have a hint for me ?

Thanks in advance.

Ernst Leber

 

[al0]

Originally posted by eledoa:
Hi there,

...

Perhpas I am missing something but I found now way to retrieve data out of a raw column. Do you have a hint for me ?

Ernst Leber

make a TQuery (or TDataSet - whatever you need)
with SQL.Text set to

select * from TAB_FILINH

Then Field('ZEILE').Value (or Fileld('ZEILE').AsString) would return desired value (but converted to hexadecimal string). You may convert it back themselves if you need to.