>>>>Hi Nick,
>>>>
>>>>Actually that was very helpful. I have the grid working now, except I just realized that my "select ... into cursor temp" won't really work for what I'm trying to do because I am trying to allow the user to check which customer's he/she wants by clicking the checkbox control in the grid. The cursor I'm using is not updatable. Now as I understand it, in order to use a view which would be updatable, I would have to have a database open. The cust table that I'm selecting from is a free table from a clipper program. Any ideas on how I can get what I want short of sending the results of the sql statement to a temporary table that I create? -Rick
>>Ooops, correction.
>>>Rick,
>>>Just to notify something here. You can't contain a free table in
dbc but you can set an updatable view (contained in a dbc) for it as you would do other tables.
>>>Cetin
>>If you need transaction, that's helpfull.
>>Cetin
>
>Can't you make the cursor updatable?
>
>use dbf("cursor") again alias MyCursor in 0
Hi Nabil,
I think you missed the thread. You could create a read&write cursor with "Use again" but it can't be contained in a transaction (unless added to a dbc) nor update the base tables.
Cetin