Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checkbox - Data type mismatch
Message
From
23/06/1999 07:49:44
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:
00232880
Views:
18
Petras:

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

Sounds like you need an updateable view? Or SELECT ...INTO DBF? If you are posting the info back to the back-end, an updateable view is the best way to go. If you are merely pulling, letting the user change it, and then throwing it away, you can SELECT ... INTO DBF.
Previous
Reply
Map
View

Click here to load this message in the networking platform