Hi Peter, Some of my projects using Oracle database. And we usually use Number(1) as boolean field. We store that value with '1' for true and '0' for false. We also retrieve that value, and change into boolean value in the value object.
Correct me if i am wrong Hope this help daniel
Joined: Mar 25, 2004
Sorry I should have been more clear. Microsoft Access is the only Databasing program that refers to Boolean Fields as Yes/No Fields. What I am asking is how to do Select No fields eg I have tired
Use Access' query builder to find out. It comes with a gui tool to create queries, and there is an option to look at the "SQL" it generates (though Access SQL tends to be very different from SQL as all other databases understand it)