>This maybe an indirect argument for using views thruout an app (I'm a CB buff). In the cursors the recno's are always 1 to n regardless of the complexity of the SQL the created them even if many joins, fors, wheres. This allows a basic custom grid to be built using the AfterRowColumn change for recno setting and DynamicBackcolor in the controls. The grid can build itself basic on the data types of the control sources and us a backcolor aware textbox,edit,check, etc.
-- reply --
Gary,
Yep! You are absolutely right. Cursors are one of the most powerful features of foxpro. Having come from C through Clipper to foxpro, I probably use arrays about like you use cursors -- for anything I can. My difficulty with cursors as a grid source is that it is not that easy to update the underlying table through a cursor -- or maybe I have just not spent enough time on deriving a general solution. I probably should since I am certainly not getting the full benefit of this powerful feature.
But...
my base position is that VFP ought to provide a more direct means of controlling display of grids -- one that does not require the programmer to manipulate the underlying record source to achieve the desired grid display. Having said that, the caveat is that grid displays are so far down my wish list that they're growing mushrooms in the cellar.
Regards,
JME
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.