IDEAScript Questions

I am trying to accomplish the process described below.  I tried it by adding a new field to the master db and doing a database lookup on the wildcard table.  The lookup was successful but I was not sure how to get the value from the wildcard table to add to the new field.  I should have kept the code to post.  I believe I needed to get values from two tables but could only get them from one.
 

Hello everyone
I need some help. Does anyone know how to exclude duplicates from a table, for example by record number?
Thank in advance.
Elaine

I would like to ask the group for some help.
I have a very large table and I want to make an extraction of the most recent records. 
For example :
Vardate >= 01022023 
Vardate has an 8 digits.
Thanks

Currently I have the following interface (see attached picture).
My IDEA script is attached.
It is a simple code that allows the user to select a file. However, it uses the IDEA dialog to choose a file in the current IDEA directory.

Good morning,I'm new to the site but also to programming. I train myself on the creation of scriptIdea in order to automate repetitive tasks. Inspired by messages found on your site, I tried to develop the following script to 1) write information in a virtual field to determine unique records based on an ID and a date of action(oldest) see extract unique records directly into a new file. Nothing works. Despite

Hi IDEA friends!I want to add a variable to the script that can be set by the script user. 
Sub Main
...
 
Keyword1="test"
Keyword2="test2"
Keyword3="test3"
Keyword4=""
Keyword5=""
...
Keyword15=""
...
End Sub
 
The corresponding function:
Function Risk_Summary (Keyword1, Keyword2, Keyword3)
Set db = Client.OpenDatabase("XY.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "KEYWORD"

I have three dialog ( include main menu (displayit)).
I try to close second dialog and close third dialog at the same time. than back to first dialog.
But I failed...
however i can close third dialog and close second dialog at the same time by do some trick with the button (in second dialog) which open the third dialog.
Please tell me how can i do. 
 
 
Thanks 
Dorian

Hi!
I would like to ask for a help. I need a to calculate a working day between two dates. Is there a function or a combination functions that can do this?
Thanks a lot.

Hi all
 
I've got a weird issue with the IDEAScript editor when working on my script to do ODBC imports.
 
Using the below example of my function to import a general ledger, if I run the script it works 100% perfectly, giving me exactly the data I need. But if instead I open in IDEAScript editor then my query(0) line gets wiped out entirely and replaced with an exact copy of the line above it (ie: table = "PostGL")

Hi all
I've had a look at the script here to get an idea of how to hold multiple fields in an array
https://ideascripting.com/snippet/array-hold-all-field-information
 
Tried adapting it to my own script, attached (quite new to this so sorry if my script is hideous)
note I've trimmed out some of the stuff from my script like menus/functions that aren't applicable to this question