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


> 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.


Interesting - but when I leave the recordsourcetype as 4 and leave the bindcontrols set to .t. and build the cursor before the form it is not read only.

Dan
"Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph

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