Please HELP ME ......! [modified]
-
update TblAdvance Set check=false where ecode='1011' and type='Festival' and Check=true this query does not work it says Syntax error in update statement. when Executed in access Query it work Fine.. Please Help Me... :((:sigh: -- modified at 8:37 Thursday 28th June, 2007
-
update TblAdvance Set check=false where ecode='1011' and type='Festival' and Check=true this query does not work it says Syntax error in update statement. when Executed in access Query it work Fine.. Please Help Me... :((:sigh: -- modified at 8:37 Thursday 28th June, 2007
try this update TblAdvance Set check=true where ecode=1011 and type=Festival and Check=true Best regard Pathan
GOD HELP THOSE WHO HELP THEMSELVES
-
update TblAdvance Set check=false where ecode='1011' and type='Festival' and Check=true this query does not work it says Syntax error in update statement. when Executed in access Query it work Fine.. Please Help Me... :((:sigh: -- modified at 8:37 Thursday 28th June, 2007
Even if you did get it to run without a syntax error it doesn't do anything. It will only set check to true where check is already true. By the way, did you mean check=1
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website
-
Even if you did get it to run without a syntax error it doesn't do anything. It will only set check to true where check is already true. By the way, did you mean check=1
Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website
hi pathan thanks 4 the reply.. i should make it false..... regards DEv