>>VFP treats it as a numeric. I don't do anything special. I use checkboxes for logicals, so the values of 0 and 1 work with checkboxes without any data conversion. As for data retrievals, I just have to specify WHERE MYFIELD = 1.
>
>The problem we are facing is in our setup tables, ie race, we have a logical field Inactive. We create an array where not inactive. ComboBoxes display valid values from the array.
>
>Any suggestions on how to get VFP to think that the field is a logical in the remote view?
No. Why can't you use SELECT ... WHERE Inactive = 0 ?
You could do a SELECT ... iif(Inactive = 1, .t., .f.) as Inactive from ...
But how are you going to update the values in Oracle? You are going to be better off just going with the N/1 datatype.
Mark McCasland
Midlothian, TX USA