action script

[david dickie]

hi folks, i wrote an action script that tested o.k.,but,it doesn't run . i wrote it in the code editor for reports. in the container box,i wrote the field-name that it was to fill in. i left the script box with 'canarrive'.i was in the script tab. any help please. thanks, david

[Tom Cone Jr]

RE: action script

David,

You've described where you were when the problem occurred. Now, tell us about the problem itself.

what do you want the script to do? (describe the tables and fields involved, and explain what it is you are trying to get Alpha Five to do)

What commands statements are in the script?

-- tom

[david dickie]

RE: action script

hi tom, i'm trying to fill a field when i run a report. the field i call CCODE. if the TY field has t,s,f,m,or w and the R BK field isblank or isnotblank then each combo of the TY field and R BK field will produce a character entry in the CCODE field.I went into reports for the table i'm using;and went into the code editor. i used the select type of branching.1 select for isblank,2nd branch for isnotblank; and under each ,i wrote if TY="t" and under that i wrote xbasic CCODE="tl";etc. for all the TY field entries. so i wanted to produce a different ccode for each combo of TY to R BK depending if it isblank or not. after i wrote the script i had it code checked and it said that it was o.k.. i think i don't have it activated in the right place or some thing. in the code editor, in the container box, i typed in the field name CCODE and i left the script box on the top right with the entry CANARRIVE ; i'm not sure what these mean. thanks david

[Tom Cone Jr]

RE: action script

David,

I would not try to update values in a table field while running a report.

I suggest you put a button on your form, which calls the report to preview or print.

Use an action script in the OnPush event of the button to calculate the desired value for the field, and then print or preview the report.

If you don't want the value updated until the report successfully concludes, have your action script print or preview the report, and then prompt the user to tell Alpha Five whether or not to update the field.

In either case all of the table updates would be processed in the OnPush event of the button.

-- tom

[david dickie]

RE: action script

thanks again tom, what i wanted to do tom, was be able to print out basicly the same report, with the same records,but the different companies that recieve the same info code differently; i.e: company 'A codes the record as XYZ; the same record is coded by company 'B' as 1304. i was thinking(mistake #1) that i could do this script thing and then create a print form, that was tabbed with each company that i send the report to. am i in left field, or out of the park? thanks, david

[Tom Cone Jr]

RE: action script

David,

I think you're in the ballpark, but I am having much difficulty understanding the specific details of what you are trying to do. I won't be able to help until I understand the problem.

-- tom

[david dickie]

RE: action script

good morning tom. in each record, there are 3 fields; 1 of the fields has 6 variables; the other 2 have 2 variables. each combination of the variables is refered to differently by different companies.i.e: if field 1 has "b"'if field 2 is bblank, and field 3 has "m" in a record, this record would be called an "mx" record by company "A" , but called a "1324" record by company "B". when i print a report to each company, i need the records labelled according to there 'codes'. thanks, david

[david dickie]

RE: action script

good morning tom. i am trying to give a different "label" to the same record, depending who i send the record to. each record has 3 fields, and 1 of these fields has 6 variables; the other 2 fields are either filled or blank; depending on the variable in field 1 and whether field 2 is blank or not; that record would be 'labled' as "mx" by company A, and "1234" by company B. thanks, david

[Tom Cone Jr]

RE: action script

Let's see if I get the picture.

You have a table.

This table has records.

Each record has three fields, within which various codes have been entered.

You want to base a report on this table.

You want to use the same combination of codes to generate different codes depending upon which 'company' you are sending the report to.

Sounds to me like you need to add another field to your table. Call is something like Company_code.

Use an update operation to compute the desired Company_Code value for a particular company. Then display the Company_code field on your report.

When you get ready to send the same records to a different company, design a new update operation to stuff the correct Company_code value in each record for that particular company.

Repeat the process for each company.

If this isn't exactly what you had in mind, maybe it will give you some ideas that will help move things along.

-- tom

[david dickie]

RE: action script

thanks tom, i'll poke and hope. david

[david dickie]

RE: action script

hey tom,..............what if i add a field for each company in the table and form; each of these has a different formula to derive info from the other fields on the form....then, i make copies of the report i now have, and call each new one a company name........then i drop and drag those fields that relate to that co. into it? the company fields on the form would be auto-filled and with a skip expression.......is this /or should this be a solution? thanks,david

[Tom Cone Jr]

RE: action script

Yes, that would work. It's probably not the best design since you really shouldn't need to add a new field for each target company to whom you will be sending a report. And, if I understand correctly, each target company will have its own company_code, derived from the other fields. So that means adding two fields for each company.

Here's another idea:

If the method of deriving the company_code is systematic, rather than user entered and random, and if you ran the report for one company at a time, it would be possible to store the company name in a report level variable. Then, a new calculated field could be defined in the report for the company_code. This new calculated field could be dropped on the report, and you're good to go. Both the company name and the computed company_code could appear on the report if you wish. The new calculated field would use the variable that has the company name within it to compute a company_code using the other fields in each record of your table. (This presumes that each company would have only one company_code.)

-- tom

[david dickie]

RE: action script

i'm sorry tom, but i'm way lost and this must be frustrating as heck for you! each record would have 'ccode' field. this field could have 6 different results depending on what is entered in other fields in the record. these 6 different results maybe called, "a","b","c", etc. for 1 company, but the results would be called "132","465","724", etc. for the next company. if field A has"x" and field B has "y", then i need the ccode field to say:"wq" for company 1, but to say:"192" for company 2. i was thinking that if i had a field for each company on the form, and each one has its own formula, and is skipped, then as the record is filled, these fields will auto-filled. then with a report for each comkpany with the correspondining fields, i could just click on the report i wanted run . why do i need need 2 fields for each company on the form?thanks, david

[Tom Cone Jr]

RE: action script

Why 2 fields?

I presumed you'd need the company name in one, and the company_code in another. that way you could filter the table on company name for your report.

-- tom

[david dickie]

RE: action script

hi tom, i was thinking to have each company name be a 'code' field name on the form. then in each of these have the formulas for all the variables and combinations for that particular company. then i create a separate report layout for each company, and drag the fields that apply to that particular into that layout. i have to run a separate report anyway/ or copy for each..... so its the same amount of paper. so it would be: co.A field; co.B field; co.C field; each one would have a list of formulas .for example: co.A field formula would state; if field 'x'="t".and. field 'y' isblank then "l". co.B field would have the same formula excpt that the 'then' result would be "q". etc.,etc.with a skip rule for each, and auto filled. they wouldn't need to be dealt with. whatcha think(thats printable!)? david