IDEAScript Questions

Hi!
I want to get all different filelocations from one culumn in an array without duplicates.
 

 
Hello, I am calculating total field, and it always asks me for confirmation. I would like to know if it is possible to code the OK always. Or if the total of the column can be added in another way, the example is welcome. Thank you

Is it possible to create muliple joins across what is 6 different tables like I can do in SQL?  I have 7 Left Outer Joins in an SQL script that I'd like to duplicate withing IDEA.  We are upgraded to version 11.

Hi everyone!
I'm a beginer in Idea Script and here is a code i ended up with after having recorded a macro :
Sub Main
Set db = Client.OpenDatabase("GLOriginal-Travaillé.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "TYPE_DE_COMPTE"
field.Description = "Ajouter une type de compte pour bâtir TCD"
field.Type = WI_VIRT_CHAR

 
Hey ı wanna create new column record.But ı take error.Can you help me ?
 
 
 

I have an IDEAScript I built that I want to have run on the 21st of every month.  Is there a way to set this up?

Is it possible with IDEA scripting to read a specific value of a field into a global variable?

Hi, 
I uploaded an image below. There you should see two records. And I want to do an algebraic operation, namely division, between the two "NET" values, i.e 486.449,01/-189.093,80 and then I want to display the result in a new field and in a new database. How can I do that either with IDEA itself or with IDEAScript? Like divide the NET value where HESAPNO == "1" with the NET value where HESAPNO == "3", so that I can perform similar operations for other values of HESAPNO as well
Thanks
 

I know is just copy and paste but is it possible to join more than 2 sheets into a single *.IDM file? Any example, please?
 
Greeetings!

Hi,
 
I have a database with several codes and abbreviations in it. Second thing are all the lists with the full text description, what this codes mean. Now I want to add the text description from the lists to my database. Is there a possible way to join multiple lists in one task? I dont want to create 100 or more databases but the usual join function always creates a new dabase after every join. I found a way, to join multiple fields (with different matching fields) out of one secondary list, but not out of different lists.