Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Shawn Ottinger
  Where is Shawn Ottinger?
 Greeneville TN
 Tennessee - United States
 Shawn Ottinger
 To: chris smith
  Where is chris smith?
 Yorkshire CH CH
 Barbados
 chris smith
 Tags
Subject: RE: Grid Help
Thread ID: 748 Message ID: 753 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Wednesday, June 13, 2001 1:00:34 PM         
   


> > OK Im missing something here. I have used a grid before and things I think should work do not.
> > First - I thought I could select SQL as recordsource type and type a sql statement in the recordsource. Not working
> >
> > Second- I used a table to store my data instead. If I use another select statement to change the data in my table, the grid automatically resets all properties. I have to create a new check box for one of the columns and change the headings name everytime the change is made. This doesn't seem like it should be necessary.
> >
> > My concept of the Grid control is evidently not very good. Does anyone have any ideas that could help my understanding of why this is happening. I have two books on my desk and niether seem to be any help.
>
Her it is
SELECT seq,order_num,part_num,quantity,uom,date_requi,csba_name;
,alloy,gauge,width,length,run_rate,station,hours,fin;
FROM sched;
where station = this.value;
into table C:\workstasched;
ORDER BY Seq

then workstasched is the recordsource.

If I use SQL in the properties the data is displayed in the grid but I also get a brows window. Would into cursor solve this?

I am also having trouble being able to change data after the first refresh. It sais control is readonly but readonly is T for the grid,column, and textbox
Heeelp.
> Are you placing "INTO CURSOR cursorname" at the end of the SQL-statement in the recordsource type property? Can you post your SQL statement please.
>
> smith


ENTIRE THREAD

Grid Help Posted by Shawn Ottinger @ 6/13/2001 9:41:05 AM
RE: Grid Help Posted by chris smith @ 6/13/2001 12:35:23 PM
RE: Grid Help Posted by Shawn Ottinger @ 6/13/2001 1:00:34 PM
RE: Grid Help Posted by Ryss Unger @ 6/13/2001 1:13:26 PM
RE: Grid Help Posted by Shawn Ottinger @ 6/13/2001 2:20:13 PM
RE: Grid Help Posted by chris smith @ 6/13/2001 2:54:37 PM
RE: Grid Help Posted by Shawn Ottinger @ 6/13/2001 3:07:26 PM
RE: Grid Help Posted by Ryss Unger @ 6/13/2001 4:01:19 PM
RE: Grid Help Posted by Shawn Ottinger @ 6/14/2001 7:17:07 AM