updateing problem
-
hi every one i have problem when i update my database my primry key is three column how can i write my sql statment i am programing using access db and vb.net when i write sql="update [Section] set Cap=4 where Sectionid=123 and techid=123" it give error and when i but sectionid only it also give error
-
hi every one i have problem when i update my database my primry key is three column how can i write my sql statment i am programing using access db and vb.net when i write sql="update [Section] set Cap=4 where Sectionid=123 and techid=123" it give error and when i but sectionid only it also give error
-
It would help if you said what error, but I'll hazard a guess that you are trying to create a duplicate key. Check that you don't already have a record where Cap=4 and Sectionid=123 and techid=123
Bob Ashfield Consultants Ltd
-
yes, their will be duplicate because i can not but "and techid=123" in the sql it give error that it can not know what is after Sectionid=123 so i am asking about how can i write this thanks
i think the real challenge is trying to figure out what your question is.
-
i think the real challenge is trying to figure out what your question is.
-
hi this is the error Syntax error (missing operator) in query expression 'SectionID = 847 AND'. and sectionid is number
-
i think the real challenge is trying to figure out what your question is.
-
I suspect you have some charater datatypes, you need to encluse the values in quotes sectionid = '123' etc
Bob Ashfield Consultants Ltd
-
Post your table create script and then I'll see what I can do
Bob Ashfield Consultants Ltd