Re: INSERT INTO TEXT column

On Fri, 13 Jun 1997, Bill Ennis wrote: } Text is a Blob data type and yes inserting text is different than } char and varchar. Please post what application you want to use } to do the insertion (ESQL, 4GL, etc) and that will help you find } someone who can help you. In 4gl, you need a "locate" to handle text properly. Check out the 4gl manual(s) -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523, USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu "There is no 'maybe' in Boolean algebra." -- } } -Bill } } } } I'm trying to insert a row into a table that has a column with TEXT data type. } } } } Everyway I try to do this I get errors. Like Error -608, when I try to run a } } simple INSERT statement from the SQL Editor window. } } } } For example } } CREATE TABLE FOO (My_ID INTEGER PRIMARY KEY, BAR TEXT NOT NULL); } } INSERT INTO FOO (My_ID,Bar) VALUES (1,'Some text for this field'); } } } } In which case I get error -617, } } "A Blob Data type must be supplied within this context" } } } } How do I do that? } } } } Is there some trick to adding TEXT data into a table that is } } different from adding CHAR,VARCHAR data? } } } } Also, the application is a LiveWire one, so the methods that might be available } } to C programmers won't work in this case. } } } } Thanks. } } } } } -- } Bill Ennis Voice: 312-474-7516 } SSA Fax: 312-474-7460 } 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net }