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