Mario
|
Posted: 01/16/2006, 12:36 AM |
|
Hello,
we use SQL Server with bigint IDs and high values (e.g. 99990000000001). When I use a Recordset control and set the filter of the datasource (where) to type Integer, I get the following error:
[ArgumentException: Unable to set value for the Integer field: Unable to parse the 'Value' argument or cast it to the System.Int64 type]
BAA.Data.IntegerField.SetValue(Object Value, String format) +285
BAA.Data.FieldBase.SetValue(Object val) +22
BAA.BAAAdmin.Standort.TArbeitsstation_maint.TArbeitsstationItem.CreateFromHttpRequest() +210
When I set the filter to type Text, everything is OK. The same Behaviour is with Hidden Fields. I can't set the Type to Integer but must set it to Text.
Any ideas or suggestions?
Thank You.
Regards
Mario
|
|
|
peterr
Posts: 5971
|
Posted: 01/16/2006, 2:22 AM |
|
Contacting the support would be my suggestion.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Mario
|
Posted: 01/16/2006, 4:25 AM |
|
Hello,
it's a Bug in the file DataUtility.vb:
If You replace
Public Shared Function ParseInt(ByVal Value As String, ByVal Format As String) As Int64
Dim chDelim As Char() = {";"}
Try
If IsNothing(Format) Then Return Integer.Parse(Value)
If Format.Length = 0 Then Return Integer.Parse(Value)
with
Public Shared Function ParseInt(ByVal Value As String, ByVal Format As String) As Int64
Dim chDelim As Char() = {";"}
Try
If IsNothing(Format) Then Return Int64.Parse(Value)
If Format.Length = 0 Then Return Int64.Parse(Value)
then it work's.
Regards
Mario
|
|
|
|