Field Rules - Posting

[Jenny Lynch]

I have a quantity field in a table which contains stock item lines on a docket - and I have set the Field Rules - Posting tab - to subtract this quantity from the Qty Available feild in the main Stock master file.

Works fine - subtracts OK, adds back in when deleted etc.

However I have written some xbasic code (see below) that creates item line records automatically if the user selects a "kit" which already has all stock lines selected - to save a lot of data entry. The form has an embedded browse for the stock lines and this is automatically filled in and displayed OK.

The automatically created stock item lines in the data table look fine - except that the quantity "postimg" rules do not happen - the stock quantity field is not updated at all. It only works when the data is manually entered.

Any suggestions as to why?
-----------------------------------------------------

Code that 'auto-creates' the stock lines that belong to a kit :-

t3.fetch_first()
WHILE .NOT. t3.fetch_eof()
t2.enter_begin()
t2.docket=t1.docket
t2.stock=t3.stock
t2.quantity=t3.qty
t2.enter_end(.T.)
t3.fetch_next()
END WHILE


thanks

[Cheryl Lemire]

RE: Field Rules - Posting

Jenny,

I am not sure if this will resolve your issue or not, but when using xbasic to populate or change record data in a table, the field rules normally do not function. Try putting a 't' in the () for the table that has the posting rule.

t2.enter_begin(t)

I know this works for me with many of my field rules, however I have not tried it with a posting rule.

If this is not possible I am sure somebody else will have an alternative for you ... such as manually adding your posting rule to your xbasic code itself.

Good luck
Cheryl

[Jenny Lynch]

RE: Field Rules - Posting

Hi Cheryl

just tried

t2.enter_begin(t)

and got error message

variable "t" not found

thanks Jenny

[Jenny Lynch]

RE: Field Rules - Posting

Cheryl

just tried it with .t.

e.g. t2.enter_begin(.t.)

but that doesn't enforce the posting rule either.

Perhaps I will have to manually code in xbasic.

thanks for your help
Jenny

[Cheryl Lemire]

RE: Field Rules - Posting

Jenny,

Sorry for not giving you the proper '.t.', did not mean to make you work harder. I was assuming that t2 was the table that has the posting rule. If my assumption is wrong and t2 is not the table that has the posting rule in the field rules, then it won't work. You need to put the (.t.) in the table that has the posting rule. Basically the (.t.) enforces the field rules for that table.

I have an archive function and an audit function that I implement in the field rule record events that will not work when I use xbasic code to populate the table. For me this is because my functions are designed to use the field rules so if I use xbasic code to populate the table I have to manually code my archive and audit trails for that particular entry as the field rules will not work.

You may have to do the same thing ... unless somebody else knows how to make the posting field rule fire for you.

Good luck
Cheryl

[whanigsberg]

RE: Field Rules - Posting

Jenny,

"but that doesn't enforce the posting rule either.
Perhaps I will have to manually code in xbasic."

If I remember correctly, posting rules are not triggered by processes scripted in xbasic so you will have to script your own.

Perhaps others will verify my recollection. The place to find this would probably be the A5V5 forum.

Meanwhile, assuming you would have to script your own posting rule check out the tbl.post() method which should ease your pain.

But before you go this route verify that
tbl.enter_begin(.t.)
won't do the trick.

The logical argument specifies that field rules be enforced so perhaps you can force A5 to do the post for you after all.

Bill

[Bill Parker]

RE: Field Rules - Posting

If your table pointer is based on the current form, field rules are supposed to work.
t = table.current()
t.enter_begin(.t.)

UI type rules, like capitalization, never work from xbasic.

However if you get a pointer by
t = table.open("mytable")

Then field rules are not in effect with the exception that calculated rules and autoincrement rules are enforced.

Bill.

[Jenny Lynch]

RE: Field Rules - Posting

Bill

many thanks for your help

regards
Jenny

[Jerry Gray]

RE: Field Rules - Posting

Jenny,

I remember reading about enforcing field rules in Xbasic. I found the following in the help files:

TABLE.OPEN()

If you use the .ENTER_BEGIN() or .CHANGE_BEGIN() methods to do data entry into a table opened with the TABLE.OPEN() method, not all field rules are in effect. Engine level field rules, such as auto-increment, and validation expressions are enforced. However, user interface level field rules, such as Lookups and case conversion are not enforced. If you want all field rules to be enforced, you should open a form based on the table (you can use the FORM.LOAD() method to open the form invisibly) and then use form methods to enter data.

The (.T.) is another reference:

_TBL_.ENTER_BEGIN()

Hope this helps,
Jerry Gray