IDEAScript Questions

I want to use a check box so that the user can decide of select a option or not. Now when the user starts the second part of the script the result of the menu is send back to the boolean (BenfordsA = MainMenu.BenfordsA). The problem is have is that i want to set the default value of the check box on (true). When i set  MainMenu.BenfordsA=True before the select case it wont be changed when the user starts the second part of the script with this code BenfordsA = MainMenu.BenfordsA.

Is there a way to create a unique numeric field for several character fields? The reason is the benfords law analysis which tends to mark records as suspicious  based on different criteria (first two digits, last two digits, second order and summation). For the user i want to combine the suspicious results but i want to eleminate double results.  

I am building quite the long script but I will outline the current issue I am having and paste in the relevant code sections:
I am appending a file with the age of individuals as of the year end.  The year end date is input by the user into a dialog box, once ok is selected, I want a number of functions to run based on various inputs into the dialog box.
I am getting an error saying -Paremeter not date.  I have a number of fields that are dictated by this date, so I am hoping one fix will remove errors in all of the functions. 

Bonjour,
J'ai développé une application qui utilise des listbox dans une interface graphique. Je n'ai pas de difficulté pour afficher ces listes, ni pour récupèrer l'indice de l'élément sélectionné par l'utilisateur.
Je souhaiterai pouvoir selectionner par macro l'un des éléments de la liste (exemple : sélectionner le quatrième élément de la liste), je n'ai pas trouvé une fontion de type "maliste.SelectItem(4,true).
Existe t'il une fonction qui répond à mon besoin ?
Merci d'avance.
 

Hello,
 
I'm sorry if my question is basic but I would like to know how to get for example the value of the first column and the second line in my Idea's database ?
Thanks in advance !
Benoît

Hi
Please help
 
I have 2 tables
1st table contains value (e.g. 2, 8, 13, 17, 55, 104,)
2nd table contains 3 columns. 1st Column Start range, 2nd column End range, 3rd Column value)
I want to build a query, where second column will be added in 1st Table.....which will contain criteria and will query the value in 1st table and check the value betwene Start and End range of 2nd table...if the value is between the start and end range...then it will give the corresponding value in 3rd column of 2nd table.
E.g.
1st Table
Value

Hello,
How do i abort execution of an Idea script ?
I didn't find answers in the forum.
thank you
 

Hello Brian
 
I am working in a credit analysis and I need to create a database from scratch and populate it with data taken from another database, this process is repeated several times with different tables in a loop, but all of them have a similar structure where all the fields (except the last one) are numeric with two (or four if needed) decimal places and the last field is a date field.
My data has usually decimals values and sometimes low integer values, that is why it  is very important for the analysis to preserve the data exactly as it is.

Hi all, i need some help with a script i'm writing, it's a financial analysys, for debit and credit movements.
First i'm direct extracting by two criterias and because of that it creates me 2 new databases (the criterias are the account numbers).
After that i need to append them and do a new direct extraction with some new criteria (the criteria is the amount).

Is there a way to grab the current critera and then change it without extracting a database? For example, say I import a general ledger into IDEA that has 5 columns:
1) Customer_Name
2) Debit
3) Credit
4) Reference
5) Account_Number