I am trying to update a foxpro table that has two fields of logical type. I want to update these with values.

In my SQL Insert query I've tried 1, 0, .T., .F., True, False and a whole slew of other things to get this field to update,
and every time I get a "Data Type Mismatch" error. What's the proper value to update it?? I also notice that it
flags a syntax error if I try to do something like this:

Thanks in advance

Bharat