*URGENT* DataAdapter Help Needed

[MadMaxx]

Hey All,

 

I'm configuring a DataAdapter with the following sql statement.

 

UPDATE
   KanBan
SET
   InProgress = ?, 
   Completed = ?
WHERE
   KID IN (SELECT FIRST(KID) FROM Kanban WHERE ShipLocation = ? AND 
   PID = ? AND 
   Completed = false)

 

When I finish the configuration it gives me an error stating that

 

"Generated SELECT Statement" with an exclamation point beside it.

 

This statement worked fine in VB6.

 

Thanks to anyone who helps.

[Robby]

Are you adding this statement to the Update command of the the data adapter?

[MadMaxx]

No. I'm using this statement as the command for the DataAdapter.