>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

Can you please post the exact command you're trying?