I use the UPDATEBLOB embedded SQL statement as follows:
SetNull( lblob_image )
UPDATEBLOB tblname
SET ImageCol = :lblob_image
WHERE ID = :currentID ;
This results in an database error "blob variable may not be empty".
UPDATEBLOB prohibits a "SET ImageCol = NULL", too. How can I set a
database blob (image) column to NULL?
René
I'm not sure, but a basic update, rather than an updateblob, may do the
trick.
string ls_Temp
SetNull( ls_Temp )
UPDATE tblname
SET ImageCol = :ls_Temp
WHERE ID = :currentID ;
HTH
Ron Gallagher, CPDP
Atlanta, GA, USA
rongal...@mindspring.com
--
Juan Bautista Nunez R.
jbn...@usa.net
On Fri, 13 Feb 1998 12:00:17 +0100, René Krell says...
For other comments in this discussion group: The database column is
definitively allowed to be null.
WISQL, Sybase 11, "sp_colums tblname" returns
data_type = -4
type_name = image
precision = 2147483647
length = 16
scale = NULL
radix = NULL
nullable = 1