Subelement Not Found

[forskare]

Re: Subelement Not Found

Try:

t.contract = ""

in your script. Does the same error pop up?

Yes, in the script design window and the interactive window.

That doesn't work either, same error message.

[CraigSchumacker]

Re: Subelement Not Found

I just reread your post.

Please do not use the interactive window.

? t.change_begin()

would have to be:

t.change_begin()

You need to remove question marks and highlist the whole script to run in the Interactive window.

Have you made a backup? This should only hit the first record, but I don't know if you have this looped.

[CraigSchumacker]

Re: Subelement Not Found

I think you will need to give us (well me) a copy of the table.

[forskare]

Re: Subelement Not Found

I copied the entire script to the interactive window and pressed the Enter button after each line. The are the first few:

dim t as p

t = table.open("summarytest")

t.change_begin()

t.contract = ""
ERROR: Property not found
t.contract subelement not found.

t.applydate = NULL_VALUE()
ERROR: Property not found
t.applydate subelement not found.


I attac a file in a few.

[CraigSchumacker]

Re: Subelement Not Found

Allready made the table. testing now.

[Stan Mathews]

Re: Subelement Not Found

t = table.open("summarytest")
? t.field_name_get()

Will dump the summarytest field names to the interactive editor.

[CraigSchumacker]

Re: Subelement Not Found

Your table and script work perfectly, here.

Try your script with the attached table.

Create a new folder, a new database in that folder, and add this table.

Then copy your script and try it.

[forskare]

Re: Subelement Not Found

Attached is a zip file of the table with 35 records. You may have to copy the script from above.

Thanks much.

[CraigSchumacker]

Re: Subelement Not Found

Your script works perfectly on your posted table.

I did change the name of the table from:

'Null Test'

to:

'NullTest'

as I didn't like the space in there

[CraigSchumacker]

Re: Subelement Not Found

Kenn:

Try closing Alpha again.

I get the feeling you might be tainting your results by using the Interactive Window.

Try just the script window.

Craig

[forskare]

Re: Subelement Not Found

I downloaded and your script works fine, even in my database. Perhaps the table has an issue so I'll work with it a bit and report back. Thank you for your assistance.

[CraigSchumacker]

Re: Subelement Not Found

Check the field rules and table events in the field rules.

Good luck.

[forskare]

Re: Subelement Not Found

I removed the field rules one at a time. The error kept popping up until they were all deleted until except for the autoinc field. Did a db compact and the ran the script and it worked. Well sorta. I only worked on the first record. Does the script need to be changed to include all fields or is it supposed to null the fields in all records?

Thanks again,

[Stan Mathews]

Re: Subelement Not Found

Called a loop, Ken.

dim t as p
t = table.open("summarytest")
t.fetch_first()
while .not. t.fetch_eof()
t.change_begin()
t.contract = NULL_VALUE()
t.applydate = NULL_VALUE()
t.techinitials = NULL_VALUE()
t.datepaid = NULL_VALUE()
t.sale = NULL_VALUE()
t.chk = NULL_VALUE()
t.paid = NULL_VALUE()
t.combinedrate = NULL_VALUE()
t.ppd = NULL_VALUE()
t.year_chg = NULL_VALUE()
t.year = NULL_VALUE()
t.discount = NULL_VALUE()
t.change_end(.t.)
t.fetch_next()
end while
t.close()

[Tom Cone Jr]

Re: Subelement Not Found

Kenn,

I wonder if the error message you were seeing happened because you might have been trying to assign a value (i.e. null_value() ) to fields defined as "calculated fields" in your table field rules? You can't do that of course. Assignments to calc fields are forbidden.