Jeff Turkington
|
| Posted: 06/04/2002, 9:18 PM |
|
I'm having a problem with checkboxes displaying properly on record forms on the final release of studio. These same forms accept values ok and insert/update into the database ok, it's just the display that doesn't work...
Project db properties are set to SQL, 1;0 for boolean. The checkbox on the form properties are Boolean, set=1, unset=0. (I tried other combinations also with no luck.)
Any ideas anyone?
development platform: CCS 1.0.6, ASP 3/Template target
application server: XP Pro, IIS (also has .net Framework, same box as above)
database: Win 2000 Srv, SQL 2000 SP2
Thanks,
Jeff
|
|
|
 |
Jeff Turkington
|
| Posted: 06/04/2002, 9:30 PM |
|
Sorry, forgot to mention that the column in the db is a bit field.
Jeff
|
|
|
|
Jeff Turkington
|
| Posted: 06/04/2002, 10:46 PM |
|
OK, solved it I think...
I needed to make the CCS control source data type INTEGER, checked = -1 and unchecked = 0. *All* other conbinations resulted in either a true state not displaying as checked, or an update error converting -1 or TRUE to a column data type of bit.
Other than the post a few days ago (regarding this and Access) anyone else run into this annoyance?
Jeff
|
|
|
|
|
