Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Devide in Foxpro (Read 1541 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Devide in Foxpro
10.05.14 at 15:16:47
 
Devide in Foxpro
 
It seems to be problematic to make devisions in SQL in Foxpro.  
 
select order_amt from orders; -- this query works
 
select order_amt*2 from orders; -- this query also works
 
select order_amt/2 from orders; -- this query fails with an EFAIL error
 
select order_amt*0.5 from orders; -- this query works
 
Database Type: Visual Foxpro Free Table Directory (DBF)
Provider: MSDASQL  (ODBC)
Back to top
 
« Last Edit: 10.05.14 at 15:22:42 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Foxpro ODBC is no longer supported
Reply #1 - 10.05.14 at 15:26:19
 
Foxpro ODBC is no longer supported
 
According to the page below Foxpro ODBC is no longer supported.
The VFP ODBC driver is no longer included in Microsoft Data Access Components (MDAC) version 2.6 or later versions.  
 
Microsoft recommends to use the OLE DB driver.
 
Microsoft OLE DB Provider for Visual FoxPro 9.0 can be downloaded from:
http://www.microsoft.com/en-us/download/details.aspx?id=14839
 
Source:
http://support.microsoft.com/kb/277772
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1