IDEAScript Questions

Hi
I have a script that compares fields and checks if there is a mismatch. It works fine sometimes, but seems to skip other fields at other times, especially if the fields are many, What could be the issue? I have attached the file in .txt format.
Please assist. Thanks.
 

Good afternoon:

I have to simultate a sql process which start to create a sequence of dates given initial and final date, actually an improvement would be just capture the initial date because the process is 36 months long, and generate a row using the last day of the month.

Thanks in advance for any help

Hi, my question is how to import a accdb file with password from the IS.
With ADODB (Connection and RS) object I can enter and read all items from db but can't import into a table on IDEA.
Any suggestion?
Thanks
PS: Btw, IDEA can't neither import manually a MS Access file with password. (ODBC is NOT a way for this case)

Hi
I was wondering if there was any way of attaching multiple files using Client.SendEMail?  I would like to email the output files from my script and I would like to just send one email with multiple attachments rather than multiple emails with one attachment.
Thanks
Chris

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