esqlc:how can I control image of blob datat type ..

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

�� — Sat, 18 Dec 1999 10:31:59 +0900 — source: Informix-list mailing list archive (1991-1998)

How can I control image of blob datat type .. loc_t photo; photo.loc_loctype = LOCMEMORY; photo.loc_buffer = photo_buf; photo.loc_size = 10000 - 1; and what I do add in this coding?

↪ replying to ��

Art S. Kagel — Mon, 20 Dec 1999 18:29:15 GMT — source: Informix-list mailing list archive (1991-1998)

In article <83eo4v$6ud$1@news.nuri.net>, "'ǰ'ȯ" <tiffany@myletter.net> wrote: > How can I control image of blob datat type .. > loc_t photo; > > photo.loc_loctype = LOCMEMORY; > photo.loc_buffer = photo_buf; > photo.loc_size = 10000 - 1; > and what I do add in this coding? Once you have all of the required fields of the loc_t structure, photo, set up you use it as a host variable in a INSERT statement, PUT cursor, SELECT cursor, UPDATE statement, etc. Check out the sample programs inthe samples subdirectory in $INFORMIXDIR. You can also checkout how I used BLOBs in my dbcopy.ec, ul.ec, and myschema.ec utilities which are contained in the package utils2_ak in the IIUG Software Repository. Art S. Kagel Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary

ESQL/C