Thanks Razzak and Mark I'll try both methods.. Bill
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Kwoka Sent: Tuesday, November 02, 2004 3:43 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: insert Bill, Try this: SET VAR vIMAGE='sheet2.tif' SET VAR vIMAGE1=('[' + (CVAL('QUOTES')) + .vIMAGE + (CVAL('QUOTES')) + ']') LOAD IMAGES (14, &vIMAGE1) END Mark Kwoka -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Sent: Tuesday, November 02, 2004 3:33 PM To: RBG7-L Mailing List Subject: [RBG7-L] - insert I have 12 map image files (tif) i'm trying to insert into a table table name maps. 2 columns in Maps table first column= mapid integer and second column= maps varchar (no length defined for varchar in table. First question is varchar a good data type for tif file Second I use command insert into maps (mapid, maps) values (14,['sheet2.tif]) This command does not insert file I expected a row added to table maps with mapid=14 and maps(varchar field to contain tif image) Bill
