yes/no
-
can anybody tell me how can i insert into a column in microsoft access that have a yes/no datatype plz help me regards
etretyertyery
-
can anybody tell me how can i insert into a column in microsoft access that have a yes/no datatype plz help me regards
etretyertyery
I presume that yes/no would map to a boolean data type.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
I presume that yes/no would map to a boolean data type.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
their is a sample query that i use: update tblClient set exist='no' !!!! but their is something wrong in this query because it can't update the following record that have a yes/no datatype. please if we have something to do in access or something in my code so plz help me????? thanks
etretyertyery
-
their is a sample query that i use: update tblClient set exist='no' !!!! but their is something wrong in this query because it can't update the following record that have a yes/no datatype. please if we have something to do in access or something in my code so plz help me????? thanks
etretyertyery
I would suspect from your example there that the problem is the quotes around 'no'. This implies that it is a string type. Replace this with false instead.
Deja View - the feeling that you've seen this post before.
-
I would suspect from your example there that the problem is the quotes around 'no'. This implies that it is a string type. Replace this with false instead.
Deja View - the feeling that you've seen this post before.
-
I presume that yes/no would map to a boolean data type.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Access doesn't like complicated terms like boolean. It actually calls the field type Yes/No.
-
their is a sample query that i use: update tblClient set exist='no' !!!! but their is something wrong in this query because it can't update the following record that have a yes/no datatype. please if we have something to do in access or something in my code so plz help me????? thanks
etretyertyery
tantoun wrote:
set exist='no'
'no' is a string. This isn't going to work, as someone else said. It's almost certainly the case that you need to use a boolean to set it. I googled, and found this[^] within seconds. We were right, you set it using the boolean type.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Access doesn't like complicated terms like boolean. It actually calls the field type Yes/No.
Yeah, I guessed that was the case. I don't use Access, except to drive my CD database, and even then, it uses SQL Server on the back end.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )