[Joe Mamma]

\r\n

\r\n \r\n Hi
\r\nThank\'s for your answer, i have another error:
\r\nSyntax error in UPDATE statement.
\r\nI have update sub, i will not give you the whole sub only the main sentence:
\r\nstrUpdate = "Update tblUsers set UserName=@UserName, Password=@Password, RetypePassword=@RetypePassword, Email=@Email, Comments=@Comments Where UserID=@UserID"
\r\nI guess the problem is here.
\r\nThank\'s.\r\n

\r\n

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