IDEAScript Questions

Hey,
 
I am currently working on a searching filter function so I can filter a database. For this function I have a String variable as input. Somehow Idea doesn't allow me to use the Variable in this function and I just cant Figure out why.
 
Function SearchFilter(KeyWord As String)
 
task.Criteria = "@Isini(KeyWord; Column1) .OR. @Isin(KeyWord; Column2) .OR. @Isini(KeyWord; Column3) .OR. @Isini(KeyWord; Column4)"
 

Hello everyone,

I created a script for the gap detection and build some code so that would check if a letter from a string is numeric or not. I got it working but what i don't understand is that every space, dot en minus sign is recognized by the IsNumeric function als numeric. Why is that? I would expected that only number would be a valid numeric. 

I created some code to import a txt file and remove the " symbol from the array:
 
 Function ImportText1
Const fsoForReading = 1
Dim objFSO
Dim objTextStream
Dim FirstTime As Boolean
Dim FileName As String
Dim i As Integer
 
FileName = WorkingDirectory & "\Exports.ILB" & "\Temp1.DEL"
FirstTime = True
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTextStream = objFSO.OpenTextFile(FileName, fsoForReading)
Do Until objTextStream.AtEndOfStream 

For some reason I can't get the script working, it keeps crashing at Pushbutton 3 of the DialogSelectFields1A function (line 432). Can you please take a look, i first thought it would be the Dim/Redim would be reversed but thats not the case.

I know how to get fieldnames in a list, but is there a way to get the content of a field in a listbox? (Such as debtor names or general ledger ID's)
 
Update:
I got to the point to summarize the selected field (general ledger ID) and export only the content of that field to a txt file and then import it.
 
Open WorkingDirectory & "\Temp.DEL" For Input As File1
Line Input #File1, Contents
MsgBox "The file contains: " & Contents
 

In the summarization function IDEA wants to know what statistics functions to use. When all are selected the code is as follows: task.StatisticsToInclude = SM_SUM + SM_MAX + SM_MIN + SM_AVERAGE + SM_VARIANCE + SM_STD_DEV
 
I created check boxes in a dialog menu so the user can select the statistics function they want to use. The check boxes are set as boolean, but i added a If function that when a statistic function is selected (example sum) a variable (sting) is set with SM_Sum and if not it is set to "". 
 

Is there a way to let the user define a number and than the script creates that number of variables (dim as string)? I thought i would be something likes this:
 
Option Explicit
Dim LimitQ As String
Dim i As Integer
LimitQ = 5
For i =0 To LimitQ
Dim Limit(i) As String
Next i
Sub main
End Sub
 
 
 

I want to create a dropdown menu with the fieldnames. In my test script (Test fields to dropdown menu works) it works but in my project script (RB Temp 1) it doesn't work. What do i wrong? I want to understand how the basic code is to populate a list and show it to the user.
 

I'am trying to understand how to work with the function displayIt and the select case Action% and select case ControlId$. But i can't get it working on a simple script, what do i wrong? :
-----------------------------------------------------------------
Begin Dialog MainMenu 50,50,150,150,"NewDialog", .NewDialog
  CancelButton 93,109,40,15, "Cancel", .CancelButton1
  OKButton 9,110,40,14, "OK", .OKButton1
  PushButton 66,20,40,14, "Get File", .PushButton1
End Dialog
Option Explicit
 
Dim Exit_Script As Boolean