home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,546 of 10,840   
   David C. Barber to All   
   Handling 64-bit integers in VB6   
   06 Jun 05 22:57:43   
   
   From: david@NOSPAMdbarber.com   
      
   SQL Server 'bigint' values are 8-bytes, or 64-bits.  While VB.NET has a   
   specific SQL variable types to mirror each SQL Server data type, I'm working   
   in VB6.  So what is the best way to manipulate, or at least retrieve and   
   store 64-bit values in SQL Server?   
      
   Considerations are:   
      
   1: Variant   
   2: Type value using a pair of 32-bit long integers.   
   3: A class object to handle it, and could track null values as well.   
   4: Other   
      
   What won't work include:   
      
   1: Double precision float (not enough precision)   
   2: Currency (can't handle the maximum 64-bit values)   
      
   Suggestions?   
      
       *David*   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca