If a table t is created with a column c VarChar NOT NULL DEFAULT
'' (the last is a pair of single quotes signifying an empty string),
then attempting to edit the field from a recordset always fails if
the string you assign is empty. That is,
rs=db.sqlselect("SELECT c FROM t")
rs.edit
rs.idxfield(1).StringValue=""
rs.update
always gives an error to the effect that t.c may not be NULL. As
there is no problem doing this with an INSERT INTO or via a
DatabaseRecord, I think it means there is a bug in Recordset.edit/
update. I filed a report "hpruyesk". Happens on both Mac and PC,
RB2006 r3. Workaround is either (a) don't use NOT NULL DEFAULT '' on
a VarChar column; or (b) don't use recordset.edit on such columns.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
