🚀 go-pugleaf

Sorry, I was wrong.  The script worked fine, but if I use the same SQL
statement from within my program it fails when I try and assign a field as a
'Float' datatype.

How come the SQL statement from a JScript works but fails when the same SQL
statement is used from within a Builder component? ...when they are both
being operated against the same MS Access database?

can anyone explain this?


"Daniel" <admin@netcomm.com> wrote in message
news:3f95c6f9$1@newsgroups.borland.com...
> 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>