| Author |
ULColumn.StringValue not returning String
|
|
| handheldmaster 2005-10-27, 7:41 am |
| Appforge MobileVB 3.5 (0633) -- Ultralite 9.0.2.3137 - Windows Mobile 2003
Have function to avoid SQLE_CONVERSION_ERRO
R if record has NULL value
Public Function nullToString(col As ULColumn) As String
If col.IsNull Then
nullToString = ""
Else
nullToString = col.StringValue
End If
End Function
If record has a value of 3601771067 and nullToString (MyTable.mycolumn) is
called it returns 3601771067.000048 ? basically a decimal value. The column
has datatype character(20)
Is this a known issue ? Any workarounds ... Am thinking that can use the
CStr(CDouble(col.StringValue)) .. Convert to Double & String functions that
MobileVB provides.
TIA
| |
| Greg Fenton 2005-10-27, 7:41 am |
| handheldmaster wrote:
>
> If record has a value of 3601771067 and nullToString (MyTable.mycolumn) is
> called it returns 3601771067.000048 ? basically a decimal value. The column
> has datatype character(20)
>
Can you provide a simple repro (a simple MobileVB app and a UDB
containing the offending data) and submit it either via iAnywhere
Technical Support or via CaseXpress (http://case-express.sybase.com/)?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| handheldmaster 2005-10-27, 7:41 am |
| >
> Can you provide a simple repro (a simple MobileVB app and a UDB containing
> the offending data) ....
Well looks like my bad .. cannot recreate in a demo application. Looks like
when the data is getting inserted is the cause. Plan to sit down and
step-through debug the code line-by-line.
Thx
|
|
|
|