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