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: 155098 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Monday, December 24, 2007 4:09:30 PM         
   


> 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.
>
> Indeed - perhaps this is a bug - or at least a bug in the help file because the help file says that when the RecordSourceType is 4 the RecordSource is ReadOnly < s >.
>
> Regards,
> Marcia G. Akins
> Tightline Computers, Inc.


Marcia,
Interesting - not in my help file (though I certainly could have missed it :) )

Specifies how the data source that populates the Grid control is opened. Available at design time and read/write at run time.


Grid.RecordSourceType[ = nType]


Return Value
nType


The settings for the RecordSourceType property are:
Setting Description
0 Table. Automatically opens the table specified in the RecordSource property setting.

1 (Default) Alias. Treats the record source as specified.

2 Prompt. The user is prompted for the record source at run time. If a database is open, the user can choose one of the tables it contains as a record source.

3 Query (.qpr). The RecordSource property setting specifies a .qpr file.

4 SQL Statement. The SQL statement is specified in the RecordSource property.


In any case, give it a try and see what it does - I'm curious to see if it is read only for you.



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