When connect to a fox pro table with ADO Connection with next connection string: "Provider=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc; Collating Sequence=machine;" the decimal value of numeric field are not read correct but only the integer value appear without decimal. Another bug or feature request: the ability of applying more filter to the field beacuse now max only three filter can be applied to the table. Please correct. Thanks.
@scocacc: please provide a sample test file and instructions for setting up the connection if possible For exeample, your ADO connection states Provide=vfpoledb - what kind of provider is this ? Is it a specific database driver that comes with FoxPro 9, or is it present by default on Windows systems ? SETTING to NEEDINFO pending requested information. Please set to UNCONFIRMED again once this information has been provided. Please open a separate report for the number of filters available - quite possibly a bug request for enhancement for this functionality has already been filed (although I couldn't find it after a brief search in bugzilla).
@scoccac : please also indicate the version of LibreOffice you are using.
To replicate the bug you can create a new connection to external database and using the previous indicate connection string. vfpoledb is an OLE Db microsoft external driver available at http://www.microsoft.com/en-us/download/details.aspx?id=14839. I'm using 4.4.0.3 version of Libreoffice. I hope these info are enough. I'm available for other info. Thanks
@scocacc: please provide a sample test file. Also please test with actual version 4.4.2.2.
Created attachment 114670 [details] Database files for testing ADO connection Open "Articoli" table, column "listino1" has a decimal value 10,000 with libre office base but the real value is 10,586
Files contains foxpro table with a table "articoli" and a column "listino1". The value read by Libreoffice base is 10.000 but the real value is 10.586
I updated the version of libreoffice to 4.4.2.2 but the bug is living.
is alive:)
Created attachment 114671 [details] import from dbf into base import from dbf into base with embedded base driver
Embedded dBase driver does not read correctly memo field i attach new file with memo field filled with: "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum." But no words are display.
Created attachment 114673 [details] Articoli table with Memo filed filled
For this reason I use VFP ole db driver for MEMO field but has a bug...(like dBase driver).
I found why decimal number are not displayed correctly using microsoft ole db driver in libreoffice dBase ADO connections: the number values are retrived using windows locale number separators. Now in Italy decimas separators is "," meanwhile EN using ".". This is the reason because the decimal values are not read correctly. I not found anyway to solve this issue only change the windows system values.
Per comment 13, OP has found a workaround, so WFM