Re: Inserting BLOB BYTE value in table

Thanks Octav, That appears to work. I wrote a small program that I call with the primary key and the name of the file. Now, I'll try to implement it in my D4GL main app. Candy -- Candy McCall ONLINE Computing, Inc. (candym@olcinc.com) >Well, you can load binary data into the database >in 4GL programs. To do this you could use the >following code (I didn't test it): > >DEFINE myBLOB BYTE > >LOCATE myBLOB IN FILE "mypicture.bmp" > >INSERT INTO ablobtable(ablobcol) VALUES(myBLOB)> >-- Well, it should work. >-- As I know the same works with UPDATEs > >Hope it helps, >Octav > >Candy McCall wrote: >>I've searched the IIUG archive on inserting >>BLOBs in tables. I'd like to do this >>on IDS 7.3 on NT. I downloaded the UPDBLOB >>ESQL/C program from the archive, but then >>realized I needed to have it compiled in >>Dynamic-4GL and wasn't sure how to do that. >>I've looked at the LOCATE statement in 4GL >>but it looks that statement is only useful for >>writing blobs from the database to disk >>(please correct me if I'm wrong there). >>I want to show pictures for an inventory >>item using Dynamic-4GL and i think I >>can do it except I don't know how to get >>the data in the database to begin with. >>(This is for a demo, not production). >>I tried to load a .bmp file using load >>command in dbaccess on NT but it >>gave the message that it's not in proper >>ASCII hexadecimal format. How can >>I do this on NT? >> >>Thanks! >>Candy >>-- >>Candy McCall >>ONLINE Computing, Inc. >>(candym@olcinc.com) >> > >-- >Octav Chiriac Phone: (373) 2 21 20 96 >NetInfo S.R.L. Fax: (373) 2 21 36 59 >Chisinau (373) 2 24 00 83 >Moldova, Republic of mailto:com@netinfo-moldova.com >