Field on form refuses to update table using simple ObjectPal - what am I missing?

[ColumbiaDiver]

Hi All,

I have an old customer that is still running Paradox 7 and they asked me to make a few changes for them on a application I wrote for them. There is a field defined that basically says if the value of this field = YES then update the following fields with the specified data. They wanted me to add another item to this which I did and it will not update the table for some reason, the other items update just fine and even the items that I remarked out in the past will update if I add them back in, but not the new field.

I have checked , rechecked and triple checked and the field in the table and the field in the form are identical. I tried deleting some old no longer used fields in the table in case I had exceeded the max fields per table, no dice. I changed the field from a numeric to a Alpha, no dice.

I've been beating my head against this wall for the last 4 hours and I can't figure out what's wrong. Hopefully someone can look at it and go oh, you need to do this. I just don't get it, it just refuses to acknowledge and populate that field in the table from the code below.

Thanks

Gordon

Here is the code

method action(var eventInfo ActionEvent)

if addrlbls = "NO" and packagea = "YES" then

disabledefault

msgstop("ALERT","address labels box must be checked with a valid address before continuing")

addrlbls.moveto()

else

if packagea = "YES" then

disabledefault

pkgenvslqty = 10 ; Qty chnaged fom 5 to 10 for 0910

packageann = 50

PKGSWEAT = 1 ; [highlight #FCE94F]This is the new item I've added the field is numeric short. All the others work just fine[/highlight]

packagenmcrd = 100

;pkgmdploma = 1 ; I restored this one and it worked just fine.[highlight #FCE94F][/highlight]

pkgpremks = 1

;pkganncvr = 1 Removed for 0910 changes

pkgaddrlbls = 3

pkgmembkd.moveto()

endif

endif

endmethod

 

[Bystander]

Simplistic suggestion I know but don't forget that Paradox is case sensitive. I only say this because it jumps out at me that your PKGSWEAT field is in block capitals in your code while all other fields are lower case. Is it possible that the field naming convention in your database table is lower case?