Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add columns to cursor
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Add columns to cursor
Miscellaneous
Thread ID:
00817815
Message ID:
00817815
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform