Home All Groups Group Topic Archive Search About

SQL error with Access DB

Author
17 Nov 2006 11:19 PM
Warex
Hello,

I am slowly gaining ground eroor by error.

what does error in sql syntax with insert mean? and what do I look for? how?

I set up my primary key and the commandbuilder.

According to the MS docs, the command builder creates all the syntax for
insert delete update commands.
but seemingly this is not true... Any suggestions

Author
18 Nov 2006 2:03 PM
Cor Ligthert [MVP]
Warex,

As long as your select statement is complete and you do not use more than
100 fields, without a key the commandbuilder can by instance do nothing,

Cor

Show quoteHide quote
"Warex" <Igiveitalla***@juno.com> schreef in bericht
news:%23qhQH7pCHHA.1224@TK2MSFTNGP04.phx.gbl...
> Hello,
>
> I am slowly gaining ground eroor by error.
>
> what does error in sql syntax with insert mean? and what do I look for?
> how?
>
> I set up my primary key and the commandbuilder.
>
> According to the MS docs, the command builder creates all the syntax for
> insert delete update commands.
> but seemingly this is not true... Any suggestions
>