Re: SQL INSERT syntax error, but the statement is correct!

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

From: kosta (Kostagroups_at_dodgeit.com)
Date: 10/18/04 

Date: 18 Oct 2004 11:31:29 -0700

Jon Skeet [C# MVP] <skeet@pobox.com> wrote in message news:<MPG.1bdccd4d6682cc4a98b70d@msnews.microsoft.com>...
> <anonymous@discussions.microsoft.com> wrote:
> > first of all, I havent tried to use another date format,
> > but i have numerous other insert queries with the same
> > format, which work just fine, so I really dont think that's
> > the problem...
>
> If you haven't tried, you just don't know. If you can't see anything
> wrong, but people have suggested a way of testing something, why not
> test it?
>
> > as for the OleDbParameter, could you please elaborate a
> > bit? Im kinda doing what ive been taught... cwhy is my way
> > wrong/not a good idea? what adventeges does oledbparameter
> > has over my way? and how is it used?
>
> See http://www.pobox.com/~skeet/csharp/faq/#db.parameters
>
> If you've been taught to embed values in SQL statements, btw, I would
> have a very close look at what else you've been taught from the same
> source.

wow, ive been posting from msdn... now i looked at it from google
groups since it finally worked, and I see that i maw maybe half of the
messages posted...

thanks to everyone who posted! I will try all of these!

Relevant Pages

  • Re: SQL INSERT syntax error, but the statement is correct!
    ... > but i have numerous other insert queries with the same ... > format, which work just fine, so I really dont think that's ... Im kinda doing what ive been taught... ... what adventeges does oledbparameter ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL INSERT syntax error, but the statement is correct!
    ... first of all, I havent tried to use another date format, ... but i have numerous other insert queries with the same ... format, which work just fine, so I really dont think that's ... what adventeges does oledbparameter ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Newbie question regarding text strings
    ... >queries one after the other just to get the data in the right format. ... Author has articles and the relationship will be on AuthorId. ... export the Query result to Word as a .csv file ...
    (microsoft.public.access.queries)
  • Re: Table cell display differences between 97 and XP
    ... > fields from the access queries to calculate VAT will not ... > display in Word in the correct format ie £11.17 it prints ... > the results were merged to various Word documents as ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Directory question - need input
    ... I taught through a number of places... ... with your local school district -- they should have some community education curriculum. ... The form that you will fill out dumps the data into a spreadsheet format ... LN takes this data and also creates a two column word processing ...
    (rec.crafts.textiles.quilting)