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