home bbs files messages ]

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

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

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

   Message 7,882 of 9,834   
   Anders Jonsson to All   
   Re: Paradox DB and TIME field   
   24 Oct 06 19:38:21   
   
   From: gt3TakeThisAway@bredband.net   
      
   > Where would I find the right driver to solve this problem?!   
   >   
   > I just used the ODBC driver that was in the list when setting up my   
   > connection (one provided by windows).   
      
      
   I did a test from Excel using an ODBC connection to a Paradox table using a   
   Microsoft Paradox driver (for version 5). The table was Paradox version 7.   
      
   The time fields all came back as datetime with the "date" "1900-01-00'   
   followed by the correct time. When I format the result as time in Excel I   
   get the correct result. If I format as numeric I get a decimal and if I   
   multiply that with 24 I get the time of day in decimal form (12.5 meaning   
   12:30:00)   
      
   Bottom line, I think what you get back will be possible to use if you just   
   can figure out what you actually see.   
      
      
      
   Anders   
      
   --- 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