RE: vb6/ADO 2.8/ DB2

I need to clarify: the actual data returned is 98,99,100,101 but in my vb
app the value 100 is actually returned as 1 ('Yes' to Daniel). When I use
another tool to do the query (Hummingbird BI Query) I see the correct values
(100,1000, etc). the sql is quite simple: 'SELECT * FROM Table ORDER BY
Table.jField'. When I loop thru the recordset looking at jField (datatype
long) I get:

....98,99,1,101,...999,1,1001,..1049,105,1051...

"OldVaxGuy" wrote:

I'm getting data from a DB2 database in a vb6 application. When longs are
returned it seems like trailing zeros are dropped ie I get a sequence of
values like 98,99,1,101. Any clues?
.

Relevant Pages

  • Re: Calculating Query
    ... possible please clarify it for me. ... >> I have created a query that pulls information from two tables and ... The query pulls one column from table A and one from table B. ... >> an expression that will insert a zero when no data is present. ...
    (microsoft.public.access.queries)
  • Re: Calculating Query
    ... If possible please clarify it for me. ... I have created a query that pulls information from two tables and calculates. ... Oakland, CA ...
    (microsoft.public.access.queries)
  • Re: Database Replication
    ... I agree with Adam, but just to clarify, if you mean queries applied to the ... publisher then there' s no issue, but if the query is to the subscriber, you ...
    (microsoft.public.sqlserver.replication)
  • Re: The Archeologist of Melodies
    ... Kindly clarify what you wish to say. ... Kiran is an ... I have answered, assuming your query ...
    (rec.music.indian.misc)
  • Re: Combining multiple datatables on a unique ID
    ... Thanks for your clarify. ... there isn't a way to query ... across DataTables in a DataSet in this case. ...
    (microsoft.public.dotnet.framework.adonet)