Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Newbie - can't edit recs in grid (The record is read-onl
Message
 
 
To
26/10/2006 01:16:55
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01164636
Message ID:
01164719
Views:
8
Hi Mike,

First of all let me tell you that the general consensus advocating against direct editting in the grid.

Having said that, what exactly is the record source of the grid and its columns? If you want to use table (better to use a local view) directly, you need to specify this table as recordsource for the grid and specify 1 (Alias) as recordsourcetype. You need to put Table.Field in the controlsources for your columns in order for them to be editable.

>Please bear with a VFP (ver 6) newbie :) I have many years of FoxPro 2.x Win/DOS experience, but VFP is new to me.
>
>I have a FPW 2.6 project that I converted to VFP6 (using VFP conversion tool). On one form I added a grid object, defining all the columns, their sources etc. None of the grid columns have their Read-Only property set. The grid's RecordSourceType is Alias, the RecordSource is the name of a table used in this form. Yet when I run the program the grid will not allow any editing. If I try typing into any of the text boxes, a message appears on status line "The record is read-only."
>
>The tables are all free type tables from FPW 2.6. If I add a Browse command in the grid object's INIT event, the expected table appears and I can edit fields. Interestingly though, when I exit the browse and enter the grid - any changes I had made in the browse do not appear in the grid.
>
>I'm guessing that the grid is using a cursor rather than the actual table? In 2.x cursors are always read-only. If this is my problem, how do I make the grid NOT read-only? Do I change the buffering mode?
>
>TIA,
>
>-Mike
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform