I've seen some conversation on this list about blob types but never really an answer.
I'm having the problem where I'm trying to insert text into a blob but I'm getting the
error message:
Warning: Interbase: conversion error from string "BLOB" in filename on line 13
Here's more info about the table and sql I'm using
<------------------------------------------->
create table memo (
id char(2) not null primary key,
memo blob sub_type 1);
insert into memo (id, memo) values ('2', 'Sample Text');
<------------------------------------------->
I've been told to use:
insert into memo (id, memo) values (:id, :memo) and convert the variable to :memo but
that doesn't work either - instead I get a parse error on line whatever.
If more info is needed, please let me know. Thanks!
Ed Meyer
Smarts Broadcast Systems