can't seem to get the right syntax for using the UPDATE and SET statement getting an error line at the "notxt" variable. i'm trying to minus a variable in the database by 1 every time an action is performed here is the code
and what type is stat i am presuming it is a Statement, but it may not be.
Joined: Sep 18, 2012
Yes its stat is statement. There is no exception cause i've not run the code yet due to the error line appearing at the "notxt" variable. Want to know how to put the quotations or declare the variable if it is in the wrong way. Then please i dont know how to add the WHERE clause due to the earlier error. Thanks
Can you tell us what this "error" is? For all we know it's a compiler error and nothing at all to do with the syntax of your SQL. So copy it from wherever you're seeing it, and post it in a reply here.