SQL genius

  • Thread starter Thread starter Nitromuse
  • Start date Start date
N

Nitromuse

Between me and the data adapter wizard we can't seem to
get the UPDATE command right ..

UPDATE Emp
SET Allow = ?, EmpNo = ?, First = ?
WHERE (Allow = '?') AND (EmpNo = '?') AND (First
= '?')

I want to be able to update all the columns eventually !

Whatz wrong with this mess ??
Thanx for the help,
 
Nitromuse said:
Between me and the data adapter wizard we can't seem to
get the UPDATE command right ..

UPDATE Emp
SET Allow = ?, EmpNo = ?, First = ?
WHERE (Allow = '?') AND (EmpNo = '?') AND (First
= '?')

I want to be able to update all the columns eventually !
Click to expand...

Here are only VB.NET geniuses. The SQL geniuses are at
microsoft.public.dotnet.framework.adonet

;-)
 
I would post this to the ADONET newsgroup.

Regards - OHM#

Between me and the data adapter wizard we can't seem to
get the UPDATE command right ..

UPDATE Emp
SET Allow = ?, EmpNo = ?, First = ?
WHERE (Allow = '?') AND (EmpNo = '?') AND (First
= '?')

I want to be able to update all the columns eventually !

Whatz wrong with this mess ??
Thanx for the help,
Click to expand...

Regards - OHM# (e-mail address removed)
 
Nitromuse,

I have no time tonight to get out my list of keywords and test this out to
be sure, but when we have column names in tables such as "Allow" and "First"
sometimes we can run into problems with conflicts with keywords. Try
putting brackets around these words and see if it makes any difference. Ie
[Allow] = ...

Regards

Jerry
 
Back
Top