It reports Int values with incorrect precision which cause them to be seen as float. The VFP ODBC driver is not terribly good but it may work for your use case. I found a topic here on MySQL floats, so I set precision=0 and the VT now looks correct I'm not sure how VFP treats ints internally, but they are used in these tables as PK and FKs. įollowed samples and it seems to work fine except for an odd occurrence when the VT reads the VFP table, all integers are read as floats. I have been poking about Virtual Tables and decided to investigate their use on a little project using data from native VFP tables. Try closing the database and deleting the VT files in the C:\Lianja\data\cogema\ folder, then rebuild the VT. 'encrypted' will be displayed if there is a problem with the VT and the data cannot be accessed. You should be able to import it into a Lianja database Read/Write to FoxPro tables is not supported. then, close and open Lianja, the table is showed as "Encrypted ". I've also try to configure ODBC to access the data through ODBC, then I've created a VT. The table are opened correctly, I can use this way?
0 Comments
Leave a Reply. |