CH Chee
|
| Posted: 02/17/2002, 12:54 AM |
|
Hi
I've a DBF(Foxpro Free Table) with a logical field.
With both a check box or a textbox on a Record Form, each time I attempt to update, I get the following error message :
------- Error Message
Microsoft][ODBC Visual FoxPro Driver]Data type mismatch. (Microsoft OLE DB Provider for ODBC Drivers)
------- Error Message
|
|
|
 |
Nicole
|
| Posted: 02/18/2002, 4:41 AM |
|
Chee,
you should check couple of things. First of all make sure what logical values (1/0, true/false) are accepted by your db.
Try to execute any test query in b query analyzer.
If it is 1/0, set checkbox field type to Number and make sure that 1/0 are present in checkbox settings.
If it is "true"/"false" set checkbox field type to Text to surround values with quotes and replace 1 and 0 with "true" and "false" in beforeinsert and beforeupdate events.
|
|
|
|
CH Chee
|
| Posted: 02/18/2002, 3:57 PM |
|
Hi Nicole
Thanx for the tip !
|
|
|
|
|
