|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL error with Access DBHello,
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 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 > |
|||||||||||||||||||||||