Board index » delphi » MS-Access TTable.CreateTable Problems with ODBC.Help!

MS-Access TTable.CreateTable Problems with ODBC.Help!

I'm having a problem when I create a MS-Access table at runtime:

- In fielddefs I create a Float or currency Field and when I create the
table in the Access database appears like integer, this happends when I use
ODBC, the same code with Native Driver works OK, there's any way to correct
this using the create table?

Thank's

LEX

 

Re:MS-Access TTable.CreateTable Problems with ODBC.Help!


Quote
>- In fielddefs I create a Float or currency Field and when I create the
>table in the Access database appears like integer, this happends when I use
>ODBC, the same code with Native Driver works OK, there's any way to correct
>this using the create table?

If you use the ftBCD field type with the Access ODBC driver you get a currency
type.
If you use SQL create Table and the Float type you get a Number field of type
double in Access

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads