Re: problem with blob in ESQL/C

Hi netters, I have this problem with inserting a blob in my db. It inserts the other data fine, except blob which describe by the blobfname variable to the location of the file. All help appreciated. jaswant ---------------------------ESQL/C code ---------------------------------- #include <stdio.h> $include sqlca; $include locator.h; char errmsg[400]; main (argc,argv) int argc; char *argv[]; { $long r_req_no; $char *r_state ; $char *r_now; $char *r_date_needed; $char *r_fullname ; $char *r_login ; $char *r_cc ; $char *r_assigned ; $char *r_abstract; $char *blobfname; $loc_t cat_descr; $database "//pyramid/request"; if ( argc < 9 ) { printf("%s\\n", "Usage: addreq <list of various fields>"); exit (1); } r_state=argv[1]; r_now=argv[2]; r_date_needed=argv[3]; r_fullname=argv[4]; r_login=argv[5]; r_cc=argv[6]; r_assigned=argv[7]; r_abstract=argv[8]; blobfname=argv[9]; cat_descr.loc_loctype = LOCFNAME; cat_descr.loc_fname = blobfname; cat_descr.loc_oflags = LOC_RONLY; $insert into request (state, now, date_needed, fullname, login, cc, assigned, abstract, description) values ($r_state, $r_now, $r_date_needed, $r_fullname, $r_login, $r_cc, $r_assigned, $r_abstract, $cat_descr); err_chk("Insert"); r_req_no=sqlca.sqlerrd[1]; printf("%d",r_req_no); } /*main*/ err_chk(name) char *name; { if (sqlca.sqlcode < 0 ) { rgetmsg((short)sqlca.sqlcode, errmsg, sizeof(errmsg)); printf("\\n\\tError %d during %s: %s\\n", sqlca.sqlcode, name, errmsg); exit (1); } return((sqlca.sqlcode==SQLNOTFOUND) ? 0 : 1); } -- +-----------------------------------------------------------------------------+ Jaswant S. Bhardwaj Ext: 2651 Development Engineering Computing Services Group