Subject | Insert literal strings into blobs |
---|---|
Author | Claudio Valderrama C. |
Post date | 2000-07-04T08:14:45Z |
Remember the "How do I insert a literal string in a BLOB field" question?
The typical answer was "use a parameterized insert statements". Here, I
present a workaround:
insert into blobtable(blobfield)
values(f_strblob('Another test'));
This UDF "f_strblob" is part of Greg Deatz's freeUDFLib, available at IB's
site.
C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.tripod.com/cvalde
The typical answer was "use a parameterized insert statements". Here, I
present a workaround:
insert into blobtable(blobfield)
values(f_strblob('Another test'));
This UDF "f_strblob" is part of Greg Deatz's freeUDFLib, available at IB's
site.
C.
---------
Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente
http://members.tripod.com/cvalde