>Hi, in a select from a remote (non-VFP) table into a local cursor I include '0 as check'. In the grid the checkbox is unchecked but as soon as it is clicked it complains bitterly of 'data type mismatch'. Debugging shows the cursor field 'check' as being numeric which I believe is a valid data type for a checkbox. Can anyone help?
>
>PS. Selecting from a VFP table using '.F. as check' works fine, unfortunately the database being used does not have logical fields/literals.
>
>Rgds
Petras,
The docs claim that a checkbox can be numeric, integer, or logical. As a reality check, you can do this:
1. Create a form with a checkbox on it
2. DO MyForm Name MyCheckBoxTest
3. ? MyCheckBoxTest.Check1.Value, which should return 0
4. Check the box
5. Repeat step 3, you should get a 1.
Are you anywhere assigning the value of the checkbox in code? Have you subclassed the checkbox and assigned it a logical value?