>I have a checkbox on page inside pageframe. When the user clicks on checkbox, I should be getting a .T. value. Instead I am getting a value of "1". Here is my code:
>
>insert into employee (checkbx) value (.pf1.p3.chkdrstmt.value)
>
>
>it's giving me an error because checkbx is a logical. Its looking for .T. or .F. and I am returning a value of "1".
>
>.pf1.p3.chkdrstmt.value should have a .T. What Gives??????
>
>
>thanks
>Nick Patel

By default the checkbox.value is numerical. You should change it in the checkbox instance to .F. to have it as logical.
But more reliable approach is use IIF() function to obtain the value for your INSERT

INSERT INTO employee (checkbx) value (IIF(EMPTY(.pf1.p3.chkdrstmt.value), .f., .t.))

In this case you don't care what type the checkbox.value is.