>>Got 2 questions:
>>
>>1. Is there an equivalent field type in Oracle to the Foxpro's LOGICAL?.
>
>No. You could use a numeric data type of width 1 and use 0 for False and 1 for True.
>
>>2. I have a SQL statement which combines a local cursor already SQLed from the back-end and need to re-use on a 2nd SQL. How can I use this?.
>> Select * from table1 where filter1 into cursor cursor1
>>
>>
>> Select * from table2 where table2.code in (Select name from cursor1)
>>
>>Thanks for the responses.
>
>You can not do this. You need to submit subquery:
>
>Select * from table2 where table2.code in (Select table1.code from table1 where filter1)
>
>Use SQLExec function to return the results to a cursor.

Mark,

Could we not use unsigned INTEGER instead of NUMBER? ORACLE documentation says that you should not need to use NUMBER as an external datatype. If you do use it, ORACLE returns numeric values in its internal 21-byte binary format and will expect this format on input.