Ask Your Question

Boolean Tri State for filter table

asked 2020-06-25 14:33:19 +0200

gkick gravatar image

Boolean parameter tristate, options for listbox completion field to select are yes, no, all. Would imagine the actual values would be 0 -1 and null , is this correct? Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-06-25 19:14:44 +0200

Ratslinger gravatar image


If you are checking it from a form the values are:

 0 = Not Selected
 1 = Selected
 2 = Not Defined

Checking the value from a query:

 0 = Not Selected
 1 = Selected
 NULL = Not Defined
edit flag offensive delete link more


@Ratslinger Thank you very much for this, now to put the options into a filter listbox i guess I need to set up some dummy table aka id pk,state varchar Yes, No, All, and the stored field to be lets say value integer. Once again appreciate your help.

gkick gravatar imagegkick ( 2020-06-25 19:50:18 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-25 14:33:19 +0200

Seen: 103 times

Last updated: Jun 25