SQL genius

[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,

 

[Armin Zingler]

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 !

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

;-)

 

[One Handed Man [ OHM# ]]

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,

Regards - OHM# (e-mail address removed)

 

[Jerry]

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