[snip]
>SELECT ... FROM ... WHERE column = ?TRUE
>
>The database engine (VFP's) and ODBC will handle the conversion for you.
>

Sorry I wasn't clear enough :( By "dealing with the differences" I meant that, since the app was concurrent in VFP and SS, we wanted our SELECTs to look as similar as possible between the local and remote views, for maintenance reasons. Some things just can't be done the same in both - in this case, WHERE lLogical = .F. needs to be WHERE lLogical = 0 (for bit types). The ODBC driver doesn't handle that type of difference, and these views were too complex for the view designer. But it's true, the ODBC driver handles that conversion quite well.

[snip]
>You could have used a TinyInt. It has a size of one byte.
>

I keep forgetting that SS has several integer types. Thanks for the tip! :)

>I can't explain the behavior that you're seeing, sorry.

Yeah - with nearly 30 years combined experience at our shop, we couldn't figure it out either.


>
>-Mike