Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid refreshing
Message
From
07/08/2001 09:29:36
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00540286
Message ID:
00540629
Views:
16
>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:
*Grid1.init
with this
  .RecordSourceType = 4
  .RecordSource = 'select * from customer into cursor crsGrid'
endwith

*Commabutton.click
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform