Posting Script Problems

[Becky McNichols]

I have 2 posting codes on a Payroll form. I copied these from another set in which they work fine (on the form's "save" button and CanChange events).
First one is attached to "Save" button on form:

dim hdr as p
sys_send_keys("{F9}")
hdr=table.current()
hdr.change_begin(HONOR_FIELD_RULES)
hdr.GROSS=gross.value
hdr.NET=field1.value
hdr.change_end(.t.)

dim fund as p
dim code as c
dim total as n
dim tbl as p
dim rec as n

tbl=table.get("payroll")
code=tbl.fund_code
total=tbl.gross+tbl.bdgt_ded1+tbl.bdgt_ded2
fund=table.open("fund")
fund.index_primary_put("code")
rec=fund.fetch_find(code)
if rec

[Stan Mathews]

RE: Posting Script Problems

Deep stuff.

I'd put a:

ui_msg_box ("No matching fund code entry found for",code,UI_STOP_SYMBOL)

in the second script like you have in the first to see if the script is firing, but not finding any matching entries. I see differences in the "setup part of the code where you open and get table names and pointers, but I don't follow them on first examination.

[whanigsberg]

RE: Posting Script Problems

Becky,

Why don't you put the debugger on the second script to see what the values of the variables are and where it is going wrong.

Bill

[Becky McNichols]

RE: Posting Script Problems

I did try the debugger on the second script (I hope I did it correctly) and did find one field name I'd misspelled. I corrected it but am still getting haywire results.

If I take the second script off of the form, enter a new record and press the "Save" button (with the first script attached), the correct amount posts.

If I put the second script back on the CanChange event, enter an identical new record and press the "Save" button, some wrong amount posts (sometimes it's close, sometimes WAY off - Can't find a rhyme or reason to the amount). This is a NEW record, not an existing record which is being changed.

I've run a database compact, update indexes often. I'm about ready to throw in the towel!

[whanigsberg]

RE: Posting Script Problems

Becky,

This is just a stab in the dark since I haven't looked at your application, but why is the second script attached to the *can*-change event. This event fires *before* the form's control is edited. It seems to me that at that moment you would not yet have your new field value which could explain the erratic results. Perhaps someone will check my logic on this.

Of course, even if valid, this analysis leaves unanwsered the question of why the code worked in its initial location.

Bill

[Daryl Grace]

RE: Posting Script Problems

Becky and Bill,

I have not looked at the app yet, but I agree with Bill the script should be attached to the onchange event instead of canchange event.

Daryl

[Daryl Grace]

RE: Posting Script Problems

In my app for posting, I use the onsaverecord event and the onchangerecord event at the table level. It works great!

Daryl

[Michael Lanzieri]

RE: Posting Script Problems

Becky;

By chance are you supporting direct deposit in your payroll system? If so, perhaps we can exchange ideas on prenotes, etc.

Regards,

Michael

[Becky McNichols]

RE: Posting Script Problems

I initially attached the codes to my parent table's OnSaveRecord and OnChangeRecord events in the field rules (see my initial question under observations, please). Neither worked there - perhaps because of the code I had attached to my form's Save button which was manipulating the table (???). Anyway, putting them on the form seemed like the next logical thing to try. By adding the first code to my Save button, I at least got that to work. I know that the CanChange event is not the best choice, but there is no OnChange event on the form, and as I stated earlier, I can't get it to work in the field rules (although I'd LIKE to!).

I guess what I'd like to know is: how DO I get the second code to work from the OnChange event. Am I putting the (HONOR_FIELD_RULES) in the worng place on my first script? Any other suggestions? I think the first few lines of my first script (attached to the form's Save button) are throwing the monkey wrench in the works, but I need to have them. And, as I said, they are working in another set (??)

[Becky McNichols]

RE: Posting Script Problems

Sorry Michael,
The payroll part of my app is a no-frills component of a larger department management system (no direct deposits here). It's a very minor element causing a MAJOR headache right now!

[Selwyn Rabins]

RE: Posting Script Problems

you REALLY don't want to put a posting script on a CanChange event. the script will fire every time you start edting any value in the record.

i looked at your sample files, but could not run them because of an error message when opening the payroll form:

bdgt_ded2 not found.