topic Re: Storing/retrieving binary data in/from a database table in Application Development and Automation Discussions

Storing/retrieving binary data in/from a database table

matt — Wed, 03 Dec 2008 16:31:10 GMT

I've defined my table as:

MANDT	        MANDT	                        CLNT	3
/BIC/GLPLANT	/BIC/OIGLPLANT	                CHAR	4
/BIC/GLMATPLNT	/BIC/OIGLMATPLNT	        CHAR	18
HEXVALUE	SXIVERI_BINARY	RAWSTRING	0

I've defined my structure in my program, and read from my table

DATA: BEGIN OF ls_in_data,
        /bic/glplant   TYPE /bic/oiglplant,
        /bic/glmatplnt TYPE	/bic/oiglmatplnt,
        hexvalue       TYPE xstring,
      END OF ls_in_data.
...
* Populating ls_in_data
...
SELECT SINGLE * INTO ls_in_data FROM z_mytable...

and I get the messages:

The types for the database table and work area (or internal table) "LS_IN_DATA" are not compatible.

As far as my program goes, the hexvalue MUST be xstring. What type should I use in my database table?

thanks

matt

Re: Storing/retrieving binary data in/from a database table

ThomasZloch — Wed, 03 Dec 2008 16:39:02 GMT

Are you sure it's not because MANDT is missing in LS_IN_DATA? RAWSTRING (DDIC) corresponds to XSTRING (ABAP), as far as I know.

Thomas

Re: Storing/retrieving binary data in/from a database table

JozsefSzikszai — Wed, 03 Dec 2008 16:39:05 GMT

The client is missing from the definition in the program... Are you sure it is not necessary?

Re: Storing/retrieving binary data in/from a database table

Former Member — Wed, 03 Dec 2008 16:45:50 GMT

try into corresponding fields of; if Client is the issue in the definition, it shoul dtake care of that

SELECT SINGLE * INTO corresponding fields of ls_in_data FROM z_mytable...

Re: Storing/retrieving binary data in/from a database table

matt — Wed, 03 Dec 2008 18:50:24 GMT


> The client is missing from the definition in the program... Are you sure it is not necessary?

Of course I'm sure! I should use client specified otherwise... I'm 100% sure. Wouldn't I? ... oh dear. It does make sense. Oh well, I'm allowed one dumb question a year.

cheers

matt

Edited by: Matt on Dec 3, 2008 7:50 PM

Re: Storing/retrieving binary data in/from a database table

ThomasZloch — Thu, 04 Dec 2008 10:20:57 GMT

> I'm allowed one dumb question a year.

Even two or three...as long as I keep beating ec by ten seconds...

Re: Storing/retrieving binary data in/from a database table

JozsefSzikszai — Thu, 04 Dec 2008 10:28:55 GMT


> > I'm allowed one dumb question a year.
> 
> Even two or three...as long as I keep beating ec by ten seconds...

I was waiting and waiting and waiting sending my reply, because I did not believe that Matt overlooked it...

Re: Storing/retrieving binary data in/from a database table

ThomasZloch — Thu, 04 Dec 2008 10:36:56 GMT

Yes, I was also contemplating a bit before replying...now let's stop before somebody locks this thread...

Re: Storing/retrieving binary data in/from a database table

matt — Thu, 04 Dec 2008 12:01:37 GMT

It was one of those occasions where I'd started with one logic, then switched to another. And then just couldn't spot the error. It was the end of a long day...

Re: Storing/retrieving binary data in/from a database table

Former Member — Thu, 04 Dec 2008 12:47:35 GMT


> It was one of those occasions where I'd started with one logic, then switched to another.  And then just couldn't spot the error.   It was the end of a long day...

Join the club