If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You must register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Tried total(Ck_Detail->Amount1,grp->ckhdr) and it works in the Expresion Builder but get the following error when I try to save.
"Cannot use function in this context" I need this value stored in the Parent Amount field.
Thank you in advance.

Re: Converting Field rule from A4 to A5

This function is a report writer function, not intended for table level field rules or other expressions. While the function may perform in some areas outside of the report writer, its use there is not supported.

Re: Converting Field rule from A4 to A5

Alpha must not like the -.

Indeed not. How would Alpha decide if you were subtracting the values in two fields/tables or referring to a hypenated table name? Best to refrain from using punctuation in a name, underscores if you feel you must punctuate.

Re: Converting Field rule from A4 to A5

I started with A3 back in the 80's advanced through the Alpha 4's, currently using Alpha4v7. It was never too bad converting until Alpha 5. I have Alpha 5V11 but I just can't get the hang of it. I have written most of the reports etc but it just seems like a different beast than A4. This is what I use it for....I have a trucking company. I copy last months data base into a new data base and empty it. I enter 800+ loads...date, BL #, to, from, product, wt, rate, driver #. My reports take this info and produce an invoice by custormer and a report by driver...in order to pay them. Each month I just made a new data base. As I mentioned in A4 I just clicked on utilities, copy data base, entered the new name and all my reports and designed transferred. It is probably easy in A5 but I'm just not getting it. Wish there was a way to get some specific help to get the entire conversion done for less than $10,000.

Re: Converting Field rule from A4 to A5

Originally Posted by Stan Mathews

Correct, V5 and later do not have field rules for sets. You should be able to create a posting field rule to do that.

Was doing a search about field rules and I came across this post. In version 11, Alpha will let you create a field rule for a set although those rules are stored only in the table not the set. In the builder for a calculated rule you can select fields from different tables and then Alpha converts the expression. Which is probably not the best way to do this, since we can now create field rules that are form specific. But it did work when I tried it.

Re: Converting Field rule from A4 to A5

Possibly a question of semantics. In Alpha 4 and earlier as I understand, you could build field rules for a set stored in the set definition. With Alpha 5 and later all field rules became table based. You can build a field rule such as

but it has nothing to do with the set. That expression doesn't care whether the employee table is part of a set or not and will work if the employee table is dropped from the current set. I do find it quite helpful that the expression builder for a set allows one to specify multiple tables from the set and then converts portions involving child tables to expressions independent of the set.