Parameterize the SelectCmd much in the same way you would do for a view:
select ... from sometables ... where somefield = ?somevalue order by ...
Set the NoData property to .T. and in the LOAD of the form, you set the value of ?somevalue then call the CursorRefresh of the CA --
private somevalue
somevalue = 'blahblahblah'
THIS.DataEnvironment.adpCAName.CursorRefresh()
>Hi
>
>I have a cursor adapter (CA) that selects a group of records from my table which I display in a grid. When I do a .CursorFill it closes the table and reopens it with the new data. This destroys my grid.
>
>I tried changing the RefreshCmd and used a .CursorRefresh() but that did not change the data.
>
>How do I change the data in a cursor adapter without destrying my grid?
>
>I am a new to cursor adapters and would like to know where I can get a beginners guide. I find the VFP help somewhat short on conceptual info.
>
>Regards
>Geoff Scott
Mark McCasland
Midlothian, TX USA