Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Marcia Akins
  Where is Marcia Akins?
 Akorn
 Ohio - United States
 Marcia Akins
 To: Daniel Hofford
  Where is Daniel Hofford?
 Ocala
 Florida - United States
 Daniel Hofford
 Tags
Subject: RE: Parameters2Forms
Thread ID: 154856 Message ID: 155049 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Saturday, December 22, 2007 8:19:50 PM         
   


THIS.RECORDSOURCETYPE = 4
THIS.RECORDSOURCE ="SELECT wonum,t_in,t_out,wc,route,empid,qtybuilt,opcomp, 000 as minutes FROM timeinput ;
WHERE empid = '94' AND EMPTY(t_out) AND TTOD(t_in)=>DATE()-3 INTO CURSOR ttimeinput READWRITE"


I am not surprised that the grid is ReadOnly. This has nothing to do with setting BindControls = .T.

It is because a grid with RecordSourceType of 4 is ReadOnly - it does not matter if you direct the query results into a ReadWrite cursor.

What you should do instead in run the querey in the form's init() after you get the parameter(s) that you need and set the grid's recordSouorce to that cursor and leave the grid's RecordSourceType as 1-Alias. Then, after you run the query, set Thisform.BindControls = .T.

Regards,
Marcia G. Akins
Tightline Computers, Inc.


ENTIRE THREAD

Parameters2Forms Posted by Daniel Hofford @ 12/20/2007 6:12:11 AM
RE: Parameters2Forms Posted by Vladimir Zhuravlev @ 12/20/2007 7:12:31 AM
RE: Parameters2Forms Posted by Marcia Akins @ 12/20/2007 12:47:05 PM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/20/2007 4:48:45 PM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/20/2007 5:29:00 PM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/20/2007 5:36:59 PM
RE: Parameters2Forms Posted by Barbara Peisch @ 12/21/2007 3:29:49 AM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/21/2007 5:16:48 AM
RE: Parameters2Forms Posted by Barbara Peisch @ 12/21/2007 6:04:32 AM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/22/2007 2:05:28 AM
RE: Parameters2Forms Posted by Marcia Akins @ 12/22/2007 8:19:50 PM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/23/2007 5:10:05 AM
RE: Parameters2Forms Posted by Marcia Akins @ 12/24/2007 12:49:51 PM
RE: Parameters2Forms Posted by Daniel Hofford @ 12/24/2007 4:09:30 PM
RE: Parameters2Forms Posted by Ken Murphy @ 12/20/2007 1:39:13 PM