Field rule -posting

[lascvent]

I have two files, let us call them A & B
in A under field rules, i wrote instructions under Posting to post from A to B. that is OK
But if I erase the data on file B, how can I rerun file A to post to B gain....without re entering the data afresh???
Thanks

Wale Lasaki

[MoGrace]

The posting rule only goes from A to B, so it only will update B if A is changed.

Using Ron's Authors table from THIS POST, I made a new table for B named Posting. I added an AMOUNT field to both tables, added the Author_id to Posting for the link and created a regular posting rule in A to update B.

In the Posting field rule OnWrote field event I added this:

dim shared get_id as c = posting->author_id

In the OnSaveRecord event I added this:

dim shared get_id as c
flag = re_post(get_id)
if flag then
	trace.WriteLn("Posting "+get_id,"Scripts")
end if

Re_post function:

FUNCTION re_post AS L (vid AS C )
	re_post = .f.
	dim t1 as p
	dim t2 as p
	dim recs as n = 0
	t1 = table.open("authors",FILE_RW_SHARED)
	t2 = table.current()
	idx = t1.query_create("MNT","Author_id = "+quote(var->vid),"author_id")
        recs = idx.records_get()
	if recs = 1 then
		t2.change_begin()
			t2.amount = t1.amount
		t2.change_end()
		re_post = .t.
	end if
	t1.close()	
END FUNCTION

[Al Buchholz]

I have two files, let us call them A & B
in A under field rules, i wrote instructions under Posting to post from A to B. that is OK
But if I erase the data on file B, how can I rerun file A to post to B gain....without re entering the data afresh???
Thanks

Wale Lasaki

Wale

I build 2 operations to go along with a posting field rule.

1. an update operation to set the target field to blank or zero.

2. a posting operation to re-post all of the data from the source to the target field in the target table.

Your comment about erase the data on file B is, I'm guessing, clearing out the field, not erasing all of the records in B.....

[Ted Giles]

In one of my Invoicing apps, I too have a "fix values" process which resets the cumulative values basd on invoices, discounts, adjustments etc as sometimes stuff goes astray.

[lascvent]

Wale

I build 2 operations to go along with a posting field rule.

1. an update operation to set the target field to blank or zero.

2. a posting operation to re-post all of the data from the source to the target field in the target table.

Your comment about erase the data on file B is, I'm guessing, clearing out the field, not erasing all of the records in B.....

Yes that is what I am talking about...