Some of CB's queries contain logical data-type columns such as:
SELECT .T. As <i>lVariableName</i>
and I've made a few of my own as well. The SQL 7 upsizing wizard chokes on them. I've tried a number of ways to create a view column with logical values, but haven't got it yet. SQL uses the bit data type as it's logical equivalent, but I can't seem to get logical expressions in CB to recognize them. Do I have to go thru the framework and convert all logical expressions to arithmetic tests - say it ain't so!!! How's anybody handling logical columns in a SQL view?
Jeff Evoy
jevoy at petrasystems D.O.T com
502-243-3705
©2000 Jeff Evoy |
