IDEAScript Questions

Hi,
I am trying to automate some analysis and I don't know how to fix the following code in order to include the field as variant because I have several fields in where I need to adjust the format. Can someone help me to insert the variable field in my equation editor? This is where my code stop working, I have copied it here! Thanks
Function ModifyAllDateField (DateField, WorkingDatabase) As Variant

Hi all,
 
I have a problem with my Ideascript macros. I have a macro with different variables and object variables. So I want to send more than 4 variables to other macro but I can't. 
I see and read different solutions such as read variables from a text file (after writing) but I want to avoid use this solution...
Moreover, I didn't find a solution to send an object variable to an other Macro or may be it is not possible...
 
Thanks
 

Hi All,
Someone help me please, I want to join database A (Primary) and database B (Secondary) with "All Records in Primary File". My trouble is when in database B there is no records (this is cause depend on automatic script before) then the macro is stop.
May anyone can help me? is there any script like in excel (On Error Resume Next) to join those databases?
thank you

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?