>
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