IDEAScript Questions

I am trying to write a script for nested direct extractions and I name each extraction with a number included for which number in the sequence of nested extractions it is.  For example, I run an extraction on a database and call is EXTRACTION1, then I run a second extraction on EXTRACTION1 and call it EXTRACTION2.  When I get to the double digits of numbers I get an "Error on line 88 - bad equation provided".  On that line is "task.PerformTask 1, db.Count".  In other words, when I get to doing EXTRACTION10, the aforementioned code returns an error.

Hello~ I am new to the forum. I have looked through the site before for my questions, but am not finding any help with my specific question.
 

Hi Brian,
As far as I remember, it was possible to substitute @functions with ifunction in IDEA-script. Do you know, if it wont work any longer? Trying this, I allways got internal errors?  
Thank you very much for your assistance with this question.
Roger
 
 

Hi Brian,
I have developed a script in ACL that uses a command called the GROUP command.  The GROUP command allows you to process a single record mulitple times and in effect, lets you set up a "loop" that allows you to do different types of data analysis tasks.
Is there a similar command in IDEA or is there a way I can accomplish this same thing using the IDEA scripting language? If you have an example IDEA script that you can point me to, that would be great.
Thanks so much in advance for your help!
Mike

Hi,
I have to append a field between 2 fields.
Suppose I have fields like ID, NAME, SALARY, DEPARTMENT, PHONE etc in my database.
I have to add a new field NETSALARY between SALARY and DEPARTMENT fields. Equation for NETSALARY field will be (SALARY-500).
How can I do this using idea script?
Thanks,
Shafeer

Hello!
When using IDEAscript to run a macro to calculate the control total on a specific field, IDEA will prompt the user to accept calculating for the first time. Is there a way to bypass this using a script?
Thank you!
Shawn

Hello!
I am currently attempting to create a macro using IDEA script.
We bring in a chart of accounts database and join it with another database. To ensure consistency I want to modify the name of one of the fields each time. The naming of the field may vary each time it is imported.
For example:
"DESCRIPTION_FULL_COA" to "DESCRIPTION"
The field will almsot always include the word description in the title. Is there a way to set the following with a variable/wildcard?

I am trying to run a script that somebody else developed that creates an accumulated total field based on a user defined database and amount field and index and then create a journal number based on each set of transactions that the accumulated total nets to zero.
I am received the following error message "Error Code # 51, No cell Information", folowed by "Error on line 5999, No valid working directory"

Hi,
I'm relatively new to Idea Script. I want to call a script using an action link and I also have to pass a parameter.
How do I handle the parameter in the script? I want to pass that value to a variable but I couldn't find any info on how to do that.
Any help appreciated.
 
Thanks

Dear All
Can anyone help me with how to arrange columns automatically? Now I just can arrange it from views and save as .VW2. I want it run automatically, please anyone can help me, thank you so much.