Re: Find the Largest Integer in Column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The first step would be to check the client side type of this column.Are you
sure you don't convert this to a string when extracting the data from the db
? What Göran wanted to say is that the data type of the column is taken
into account for the calculation i.e. for now it is likely that this
smallint value is stored as a string client side and it would work if it was
really stored as a numeric value...

--
Patrice

"Randy" <spam.eastland@xxxxxxxxx> a écrit dans le message de news:
1193167361.793468.65650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have a table which contains a unique value in a column called "Idx",
which is a smallint data type. I need to find the maximum value in
this column, which I have been attempting to do with this command:

Dim intMaxIdx As Integer = CInt(Me.ds.myTable.Compute("MAX(Idx)",
Nothing))

I noticed that this command treats the values like strings rather than
integers. For example, if I have a value of 2 and a value of 11, the
value 2 is returned as the maximum value. I can't figure out how to
execute this so that it handles them like numbers, not strings.

Can anybody suggest anything?

Thanks,
Randy



.

Relevant Pages

  • Previously Functioning Date Interpreter Now Failing
    ... Dim Entry As String ... Dim Result As String ... Dim ClientElement As Variant 'Holds the extracted Client Number ... ElseIf IsNumeric= False _ ...
    (microsoft.public.excel.programming)
  • RE: Previously Functioning Date Interpreter Now Failing
    ... Dim Entry As String ... Dim Result As String ... Dim ClientElement As Variant 'Holds the extracted Client Number ... ElseIf IsNumeric= False _ ...
    (microsoft.public.excel.programming)
  • Format string bug in Half-Life client, but is it really exploitable???
    ... some weeks ago I found a format string bug in the Half-Life client. ... The bug happens when an unknown command is used and the game returns a ...
    (Vuln-Dev)
  • Re: Threading a server
    ... I am getting myself into a really big hole with this and the client is a little upset. ... private TcpListener tcpListener; ... private string CurrentCommand ... public string ExpectedSubject ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: WSE2005: Protection requirements in MutualCertificate11Asserti
    ... error when there is a algorithm mismatch between the client and the ... The Web service is using different security requeriments. ... my client, the response page is a browser page ... message, String messageContentType) ...
    (microsoft.public.dotnet.framework.webservices.enhancements)