Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checkbox - Data type mismatch
Message
 
To
21/06/1999 08:24:53
Kenneth Downs
Secure Data Software, Inc.
New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00231982
Message ID:
00232758
Views:
19
The checkbox is the last column on a grid whose recordsource is a VFP cursor. I've previously found that having a select statement for a VFP cursor with ".F. as check" allowed the user to check/uncheck although the cursor is read-only. Now that the remote database does not have logical fields/literals, I tried "0 as check" and failed. The value of the checkbox(VFP base class) is always initially set by the cursor's select statement.

>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?


>>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.
Petras Virzintas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform