Table is read-only??????????

Hi there can someone help. I am using version 8 of paradox and I am having a problem with a newly created form. The form existed previously ans a few aesthetic changes have been made. However, when I try to run the program now I get the error message:

"An error occured when setting the property named 'Value' of the object named 'Job_Number' of type 'Field'. The table is read-only."

I have traced the problem to one particular section of code. This section posts a new record with a new job number which is taken from a table and incremented by one. If I comment out one line of code the form runs properly. This line is

JOB_Number.value=currjob

currjob is simply the value of the new job. Has anyone seen problems like this before cause this is really causing me probelms. Any help would be greatly appreciated.

My first guess is that the field in question is in a child table. Check your data model. By default, Paradox sets the child table to read only when you create a link. Just right-mouseclick the table in the data model viewer and uncheck the read-only attribute.

Mac

[i]"A king will have his way in his own hall, be it folly or wisdom."[/i] - Gandalf

The only other thing I can think of is that you are creating a key violation with your code. If that's the case, once the key violation occurs during an edit no other data could be inserted. Is the job number part of a composite key?

Mac

Mac

[i]"A king will have his way in his own hall, be it folly or wisdom."[/i] - Gandalf

Thanks for replying.

I tried doing what you suggested but that was not the problem, the table that I am interested in is not set to read-only. What is confusing me though is that I am setting a number of values when I raise a new job. These include due for competion date etc, there is a list of 10 values. All of which are located in the same table. If I take out the line that sets the job number then all of the others work. How can this be the case if they are all found in the same table. Surely if it was read only for the job number field then it shouldn't work for all of the others, right?

Can you think of anything else that would cause this problem? Thanks again!

Hi there.

I am not sure why but the problem stopped happening when I pointed directly to the JOB_number field. So instead of having:

JOB_Number.value=currjob

I put in:

sales.#Box215.Box1.JOB_Number=currjob

and it started working again. Thanks again for your help though.

On a completely seperate issue, do you know why I am not allowed to use the disableDefault command in Application Events. I am using Paradox 8 and I want to put some code behind the close button at the top of the application to test that all the tables have been closed properly etc but I can't put the command disableDefault in the menuAction for my application. Why is this? Is there anyway around it. Thanks again for your help!!!