>how do you refresh a grid? I have one with the following
>WITH THISFORM.grid1
> ROWSOURCE= "Select price,quantity,noun from trans"
> ENDW
>and a click of a cmd button does the following :
>SELE TRANS
>GO TOP
>DELE next 1
>PACK
>the grid goes empty after clicking. I've tried refreshing the form too.
Tim,
I think there are some typos in code. You CAN pack your table but as a general guideline don't do it. ie:
with this
.RecordSourceType = 4
.RecordSource = 'select * from customer into cursor crsGrid'
endwith
with ThisForm.Grid1
select customer
locate for cust_id = trim(.Columns(1).Text1.Value)
delete next 1
pack
.recordsource = .recordsource
.Columns(1).Setfocus()
endwith
Cetin