>>I am populating a grid with a Cursor and I need a logical field returned from a select to use as one of the grid columns control Controlsource. For example, to create a Char field with 5 spaces in a sql statement I use --> space(5), a date field {}, but I can't remember how to create a logical field from a SQL statement. Any help appreciated!
>>
>>Thanks.
>
>NEVER MIND!!!! I have it...it's a tuff one .T., .F. Sorry for jumping the gun here!!!
>
>John
I knew you would find it in seconds. If you're doing this to insert a new empty record via SQL this tip could shorten your coding :
insert into mycursor (anyfieldtypeknown) values (emptyvalue)
scatter memvar blank
insert into mycursor from memvar
Rest will be all empty values also (default .f. for logicals).
Cetin