We are using the HXTT driver to access our FoxPro data tables in ignition and it works fine for the most part. For some of the reports, we sometimes get a 1000msec timeout when the SQL query uses dates or string functions. We’ve been working around these limitations by filtering data programmatically when needed, but I’m concerned about how the Schema for all of our FoxPro tables displays in the Database Query Browser.
Every table is duplicated, and every field of every table is duplicated in the display. Queries against these tables seem fine and I think this is just an artifact as to how the HXTT driver reads the metadata on the schema, but I want to know if anyone else has seen this behavior in the Database Query Browser.
FYI, the schema displays properly in other SQL tools.