🚀 go-pugleaf

Thanks for your help Viatcheslav,

but unfortunately the data_type 'Float' doesn't work when using it with a MS
Access database.  I have been searching endlessly to find documentation for
this, but can't seem to find anywhere where it clarifies the data_types
available when operating with a MS Access database.

the data_types I have been using so far (unsucessfully) are: Float, Double,
Decimal(n,m), Long Integer, LongInt, Long.

I have a feeling that I have to first set the field to Integer than somehow
change it the type of integer to be a Double, but I can't seem to work out
whether this theory is correct.

If anyone is a wiz with MS Access and/or know of a book or web site that may
assist in this area than I would more than greatful.



"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3f8fafca@newsgroups.borland.com...
> CREATE TABLE myTable(Field1 Float, Field2 Float)
>
> You may find info on column types in documentation for your DBMS.
>
> //----------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
>
> "Daniel" <admin@netcomm.com> �������/�������� � �������� ���������:
> news:3f8f3925$1@newsgroups.borland.com...
> > Does anyone know how to create a table with a Number of type Double as a
> > field.
> >
> > CREATE TABLE mytable (Field1 data_type, Field2 data_type)
> >
> > what is the data_type for creating a field of type Double?
> >
> > Thanks
> >
> >
>
>