UPDATE statement with Database

opuslover · **Joined:** September 11th, 2006, 2:38 pm **Posts:** 125

Anyone please help
I'm using Database and doing everything well,but when using Update I can use it only with numbers if I use variable it doesn't update
example
RecSet = db.ExecuteSQL("UPDATE Table1 SET Sales=400 WHERE City='DDD' ");
This is working perfectly
BUT

RecSet = db.ExecuteSQL("UPDATE Table1 SET Sales=myValue WHERE City='DDD' ");
(myvalue is a variable) it doesn't work
The variable is declared as public and has an input box on the same page

Duncan Lilly · **Posted:** May 15th, 2007, 5:31 pm

opuslover wrote:

RecSet = db.ExecuteSQL("UPDATE Table1 SET Sales=myValue WHERE City='DDD' ");
(myvalue is a variable) it doesn't work
The variable is declared as public and has an input box on the same page

The variable will not be expanded as you have included it in the string. You need to do this:

Code:

RecSet = db.ExecuteSQL("UPDATE Table1 SET Sales=" + myValue + " WHERE City='DDD' ");

opuslover · **Joined:** September 11th, 2006, 2:38 pm **Posts:** 125

Thanks Duncan for your reply
it's working

Digital Workshop

UPDATE statement with Database

Who is online