SQLExpress - Xb2.NET     ot4xb  
   Announcement      Free XUG Meeting Toronto/Canada (May 25, 2008)       [ More Info ... ]
sqlexpress
Error in oSqlDATASETcursor:IsNull()
Thread Starter: Mahanimann Started: 12/23/2006 10:38 PM UTC
Replies: 2
Error in oSqlDATASETcursor:IsNull()
Boris,

The new oCurs:IsNull() for SQLDataSet (in the v3.1.26 beta) falsely reports .T. in CHAR and VARCHAR fields with just spaces as a value.  Example:

cPostNumber := oCurs:FieldGet("Post_number")
? cPostNumer   reports "          " (space(10)) correctly
? oCurs:IsNull("Post_number")  // reports .T. which is wrong

Best regards,
Mahanimann
Re: Error in oSqlDATASETcursor:IsNull()
In v3.1.24 also doesnt work !

Andrej Obermajer



"Boris Borzic" <ng-at-sqlexpress-dot-net> je napisal v sporoilo news:Xns98A55B8FCE013SQLExpress@80.32.233.35 ...
"Mahanimann" <paaldalen@gmail.com> wrote in
news:yll8ia6v77aqabb.231220062336@ANDREA:

> The new oCurs:IsNull() for SQLDataSet (in the v3.1.26 beta) falsely
> reports .T. in CHAR and VARCHAR fields with just spaces as a value.
> Example:
>
> cPostNumber := oCurs:FieldGet("Post_number")
> ? cPostNumer   reports "          " (space(10)) correctly
> ? oCurs:IsNull("Post_number")  // reports .T. which is wrong

I don't see this. In my tests it works fine.

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools
Re: Error in oSqlDATASETcursor:IsNull()
"Mahanimann" <paaldalen@gmail.com> wrote in
news:yll8ia6v77aqabb.231220062336@ANDREA:  

The new oCurs:IsNull() for SQLDataSet (in the v3.1.26 beta) falsely
reports .T. in CHAR and VARCHAR fields with just spaces as a value. Example:  
cPostNumber := oCurs:FieldGet("Post_number")
? cPostNumer   reports "          " (space(10)) correctly
? oCurs:IsNull("Post_number")  // reports .T. which is wrong

I don't see this. In my tests it works fine.

Best regards,
Boris Borzic
-- news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools