Mega Code Archive

 

Categories / Delphi / ADO Database

 

Creating floats in access table results in integers being created

Question: How come when I'm using ODBC to connect to ODBC Access and I create a Table with TTable.CreateTable, fields which are type float result in being type integer? Answer: This is a problem specific to Microsoft's implementation of the Access ODBC driver. The problem does not occur with other ODBC datasources. The solution is to either use SQL to create the table or use the Native driver instead.