>When you do a SELECT you can represent a date with {}, a numeric with 0000.0 and a character with ''. How can I represent a null logical column?
>
>
>Thanks
John,
For a logical column you can use .f. (but it's .f. not null). To make it .null. you could do something like iif(recno()=1,.f.,.null.) as LogFld where in expression the first selected would be recno()=1 (SQL should catch it to determine type of field). Or you could first do a select into a true cursor, use again, alter table to add logical column (safer and cleaner).
select * from mytable ;
where .t. ;
into cursor tmp
use (dbf("tmp")) in 0 again alias altered
alter table altered add column mylogical l
Cetin