IDEAScript Questions

Hello, 
I am having a problem with using listboxs to select some data for use by the user. It only happens with one specific listbox eve4 n though the code is exactly the same. 

Hello, 
Is there an easy way to import an iss file into a script? I would like to get more structured script code.
If not is there any other way to import any self written classes or libraries? 
Thank you in advance! 
Kind regards
David
 

Hi Brian,
I have recorded a makro which includes a criterion that looks like this:
task.AddExtraction dbName, "", "(betrag <= @FieldStatistics(""BETRAG"";11)-2*@FieldStatistics(""BETRAG"";18)) .OR. (BETRAG>=-@FieldStatistics(""BETRAG"";11)+2*@FieldStatistics(""BETRAG"";18))"
In order to make it more flexible, I want to define the field name "BETRAG" as variable (part of an array). The name of the variable is Fields(3). It should look like this:

Hello,
First, excuse my bad english, i'm french :-)
I discover idea script, i have a lot of request to do in a big table. (> 100 000 records).
So i want to use "criteria" with a recordset.
like : rs.criteria " XXXX > 20150101 "
 
I have a problem :
My equation is ok, and when i browse my recordset the filter is ok ( rs.next).
But i browse the result with a loop like " While i < rs.Count"
The problem is : rs.Count don't return the number of record which match the criteria, but the whole records... So my loop don't work

Validate matching fields for join

I have a dialog that has multiple drop down combo boxes. These combo boxes share a similar attached list and I am trying to figure out a way to prevent the user from selecting the same value on multiple combo boxes. Basically a value can only be used once and I am trying to write the code to check if the user has duplicated a selection. Any advice/help anyone can offer is really appreciated.

Hi,

Hi,
I am facing an issue with full outer joining of 2 files.I am joining with 2 matching columns.  Blank fields in both files are considered as match and produced a combined row in the joined file.
Attached excel is having 4 sheets.
First 2 are primary and secondary
3rd - Actual output file after joining
4th- Expected output
Joining fields
PON (P), GRNPO (S) ASCENDING
POLN (P), GRNPOL (S) ASCENDING

Hi,
I am using @compif function in equation for appending field through idea script. This works fine in English/United states locale. When I changed locale to French, the equation is not working.
Each condition in @compif is separated by comma (,). But in French locale, it is showing that semi colon (;) has to be used for each condition.
So my code is not working in French/German locales. 

DropListBox only allowing choice#1 to be selected.