Using revDatabaseColumnNamed returns weird character when database field has NULL

Ben Rubinstein benr_mc at cogapp.com
Thu Apr 3 14:52:51 EDT 2008


On 2/4/08 20:36, mfstuart wrote:
> Testing my application that accesses MSSQL thru ODBC (in 2.8.1) on WINXP, I
> manually typed in some records into the table using Enterprise Manager. I
> left some fields without any values, and therefore MSSQL displays <NULL>,
> for no value. OK so far.
> 
> When using the subjects rev command, I see that for the fields without any
> value (<NULL>), it puts some character (a square) into the field on the
> stack.
> 
> So my question is, how do I look for nulls in a SQL table field and NOT put
> it into the field on the stack?

Hi Mark,

I think this might be a bug that is fixed in 2.9:

http://quality.runrev.com/qacenter/show_bug.cgi?id=5440

I suggest download the latest beta and test with that.

HTH,

- Ben




More information about the use-livecode mailing list