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
}