IDEAScript Questions

Hi all :)
I have a table "TableOne" that contains n fields. In field "Fieldn" there are codes like C1, C2, C3 etc.
I would like to be able to split tables: TableOne_C1, TableOne_C2, and so on.
Basically like: on every change in the column X create an extract with the new value as table-suffix.
Any suggestions?
regards from Berlin

Hi,
There is an option to wrap character fields under View. User has to select a column and click on this option to enable it.
I have to show a description field in my output file which is generated through idea script.
Width of this column is 200 and there are some other columns.  While opening the output file, user will not be able to see other columns without moving scroll bar as the width of the column is high. Is there any way to wrap text of this column programmatically?
Thanks,
Shafeer

Hey,
I want to put a statement into my errorhandler which terminates the complete script.
Is there such an easy statement?
Kind regards
David

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,