problem with editing a field within a form 3

[Phil Thoms]

I have a very simple form with 4 fields, 3 are read only and the fourth is editable but when I run the form I can't edit this field.
The property for this editable field is NOT read only so do I need to switch off/on some other property?

 

[Mike Gagnon]

Are you positionned on a blank record and an existing one?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Mike Lewis]

A few things to check:

- If the field has a control source, make sure the table has at least one record in it;

- And that the table is not at end of file.

- Make sure the control is not disabled (check the Enabled property).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Phil Thoms]

Positioned on an exisiting field. By the way I am using VFP version 6.0.
Thanks

 

[Mike Lewis]

And my other points?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

VFP6 does not differ in that respect to any newer version. If you are at EOF() of the table you bind to, it doesn't matter if the field exists and the controlsource is valid, you are not on an editable record.

The same goes if you bind to a cursor that is readonly, even if not at EOF. VFP6 has no READWRITE SQL-Select clause, so if you want to edit something, you either need to bind to a table or an updatable view.

Bye, Olaf.

 

[Phil Thoms]

The three things Mike mentioned are all OK.
Table has many records.
Not at end of file.
Control is not disabled.

 

[jimstarr]

Another way a field (is it a textbox?) could be uneditable is if the When event contains code that returns .F. A longshot, but possible.


Jim

 

[Olaf Doschke]

In regard to When,

also Valid could simply deny changes, interactivechange can also be programmed to reset the original value.


You didn't even mention yet, how you bind the textbox to the field. What's your controlsource? If it's just the field name, for example, it is very depending on the table being the selected workarea.

And what is your controlsource, is it a table, really, or is it a cursor you create via SQL or is it a view or is it a cursor created by sqlexec or what?

Bye, Olaf.

 

[Mike Lewis]

Well, the next step is to look at all the properties of the control that have been been changed (they show up in bold in the properties window). Do the same for the form's properties. And also all the method code.

Try reversing the changes, one by one, until the problem goes away.

Alternatively, remove the control from the form. Then add another textbox (or whatever it is) in its place. Gradually change the properties and add the method as they were before until the problem comes back.

Either way, that should tell you want is causing the problem.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Phil Thoms]

I will try all you recommend. Thanks to all.