select ..., .f. as LogicField from table where ... and LogicField = 0
union
select ..., .t. as LogicField from table where ... and LogicField = 1
order by 1, 2
You have to use numeric position of fields for the ORDER BY clause when using a UNION. BTW, you can not use the VFP View designer for this.
>Hi!
>
>Don't work much with DBC's can someone tell me how I can make a remote view
> convert a n(1) field (0's and 1's) to .f. and .t. with the dbc builder.
>The view is read only so I don't need to worry about updates.
>
>I tried selecting the field in the view builder and changing
>data mappinig | data type. But it gave me an error saying this is not possible...
>
>I know how to make the oracle view do this..But it would be better
>in this case if the dbc handled it.
>
>Any way to do this?
Mark McCasland
Midlothian, TX USA