Re: SQL string error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



"Norm Cook" <normcookNOSPAM@xxxxxxxxxxxx> wrote in message
news:13do4m5fvna1ve2@xxxxxxxxxxxxxxxxxxxxx
Still doesnt work. I read from the Internet that DECIMAL is not
recognised
MsAccess through this method.
Only Long, Int and Single. This is odd.
Any roundabout way to accomplish this?

From Googling, it looks like Jet SQL does not support the DECIMAL
parameter,
only NUMBER. But I assumed you were using ADO, based on the command
Con.Execute.

Try asking in microsoft.vb.database.ado



Yes Norm I am using ADO. Tks for the advice I will try the newsgroup you
recommended.

----------------------------------


.

Relevant Pages

  • Master/Detail Deletions
    ... Delphi 7 + ADO + MS ACESS ... I am trying to accomplish to delete all records from my tables utilizing ...
    (borland.public.delphi.database.ado)
  • Re: ODBC Refresh Interval
    ... Just a little reassurance on ADO, I have been using it for years without ... sql server: ... not Jet sql. ... Transact sql (tsql) is the sql language for Sql Server. ...
    (comp.databases.ms-access)
  • Re: Problem with time in access
    ... is what ADO and ADO.Net will use. ... The equivalent string command for JET SQL would be SUBSTRING ... See the Access Table of Contents and scroll down to Microsoft Jet SQL ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: timestamp
    ... Habe ich vermutet, da ADO einige Dinge drin hat, die Jet SQL Server kompatibler machen soll. ...
    (microsoft.public.de.access)
  • Re: ADOdataset loses two rows if processor is two busy (asynchronous)
    ... I'm not sure what your trying to accomplish but using ado table makes the ... program read all 800000 rows everytime you open and close the table object. ... you could fix it all by using adodataset to do the sql command you indicated ...
    (borland.public.delphi.database.ado)