🚀 go-pugleaf

I seem to not be able to execute the SQL string "Create table [MyTable]
([Field1] Float, [Field2] Float)", the error is that it doesn't recognise
what a 'Float' is, if I replace that with 'Integer', or 'Currency', or
'DateTime' then it all works.

I'm assuming from what you are saying that this is because my MDAC is not up
to date. I will have a look at updating my MDAC then try again.

I wasn't aware that MDAC affected the SQL Commands an Access Database could
recognise.


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3f937652@newsgroups.borland.com...
> Try save these strings into test.js file and execute it:
>
> //--------------------
> var connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;";
>
> var cat = new ActiveXObject("ADOX.Catalog");
> cat.Create(connStr);
> cat = null;
>
> var conn = new ActiveXObject("ADODB.Connection");
> conn.Open(connStr);
>
> conn.Execute("Create table [MyTable] ([Field1] Float, [Field2] Float)");
> //---------------------
>
> If it does not work, update your MDAC
(http://www.microsoft.com/downloads/)
> and Jet SP (http://www.microsoft.com/data/).
>
> For help on MS Jet (MS Access) SQL look for file jsetsql40.chm if you have
> MS Office installed. It may be located at: "C:\Program Files\Common
> Files\Microsoft Shared\Office10\XXXX\JETSQL40.CHM", where XXXX is language
> id, 1033 for US English.
>
> //----------------------
> 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:3f9321e3$1@newsgroups.borland.com...
> > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>