>I dont have the logical column in the table.
>The grid checkbox column is temp for the query.
>>>Hi
>>>Help please
>>>
>>>I have grid that record source is (alias of) table .
>>>I added on the grid another column for checkbox (recordsource="",sparse=.f.).
>>>
>>>How can I run somethings like "select * from myaliastable where grid.colcheckbox=1"?
>>>
>>>Tnx
>>
>>
llValue=yourgrid.column9.colcheckbox.value
>>Select * from yourtable where yourfield=llValue
select *, .F. as Checked from myTable into cursor csrGrid readwrite
And use this cursor as grid's recordsource.
If it's not broken, fix it until it is.
My Blog