Hi Nick,

ALTER TABLE works on cursors as long as they don't have long field names. You can also add a column directly into query.

SELECT PADR(ALLTRIM(fname)+' '+alltrim(lname),32) as Person, dob ;
    from person INTO CURSOR test readwrite
ALTER TABLE test ADD COLUMN Send L(1)
* OR 
SELECT PADR(ALLTRIM(fname)+' '+alltrim(lname),32) as Person, dob, .F. AS Send ;
    from person INTO CURSOR test readwrite

>I am trying to add a column to a cursor that will be displayed in a grid. Here is the code:
>
>

>SELECT ALLTRIM(fname)+' '+alltrim(lname) as Person, dob from person INTO CURSOR test readwrite
>ALTER TABLE DBF('test') ADD COLUMN Send L(1)
>thisform.g1.RecordSource='test'
>thisform.g1.Refresh
>

>
>However ALTER command is not working on the cursor. Is there a way to add column to a cursor? Also, in the grid I would like to display this added column (send) as a check box. Can I add checkbox to grid progamatically looking at cursor test.send column?
>
>Thanks
>Nick Patel