Re: SQL string error

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

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



.

Relevant Pages

  • Re: More Of The Joys Of Old Age
    ... >>the best time to accomplish stuff, ... >>asleep, the phone doesn't ring and no one thinks ... >>about in fuzzy slippers might attract some odd ...
    (soc.culture.scottish)
  • Re: Surgery is better than cataract prevention
    ... Odd, Charles. ... I'm quite sure that I know a HELL of a lot more about ... you're chiming in in an effort to accomplish the EXACT ... Otis has pushed it to the verge of extinction. ...
    (sci.med.vision)
  • Re: alternating color
    ... Candor Feg wrote: ... > How to accomplish? ... > Based on odd or even value in a field. ... In the format event of the section... ...
    (microsoft.public.access.reports)
  • Re: alternating color
    ... > Candor Feg wrote: ... >> How to accomplish? ... >> Based on odd or even value in a field. ... > In the format event of the section... ...
    (microsoft.public.access.reports)
  • Re: Page numbering
    ... A Next Page section break does *not* insert a blank sheet unless it is accompanied by a page break. ... An Odd Page break will insert a blank even page if the previous section ends on an odd page. ... But, as pointed out in answer to another of your questions, you are inserting section breaks unnecessarily because using "Different odd and even" would accomplish what you want. ... > Footer: Odd page Footer - Section 1 ...
    (microsoft.public.word.pagelayout)