IDEAScript Questions

Is it possible to generate a table preview window by idea script?

Hi,
I am fairly new to IDEA script, and I am trying to modify a macro so that it will import two new files monthly that we receive from another department.  The file names are the same except for the date at the end which is why I have tried using an input box that you can see in part of my script attached.  I am getting many syntax errors and am having trouble working around them.  Is there a better way to go about this?
 

Hello everyone,My file contains the number of tickets sold, the ticket price, type of payment, type of transaction, type of ticket and the date of the transaction.Using IDEAScript, I would like to produce 6 different tables showing the number of tickets and the enti

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