Missing Operator

[shlvy]

Hi

I wrote the next code:

strDelete = "Delete tblUsers Where UserID=@UserID"

I got the next error:

Syntax error (missing operator) in query expression 'tblUsers Where UserID=@UserID'

 

tblUsers is the DataBase Table.

I tried many things without success.

Maybe someone know why is that?

Thank's.

[Joe Mamma]

Delete FROM tblUsers Where UserID=@UserID

[shlvy]

Hi

Thank's for your answer, i have another error:

Syntax error in UPDATE statement.

I have update sub, i will not give you the whole sub only the main sentence:

strUpdate = "Update tblUsers set UserName=@UserName, Password=@Password, RetypePassword=@RetypePassword, Email=@Email, Comments=@Comments Where UserID=@UserID"

I guess the problem is here.

Thank's.