IDEAScript Questions

So far my code is pretty simple--it performs a join and extracts duplicates from the resulting database. However, I'm getting the following error when I go to perform the task in my duplicate extraction function:
 
"Invalid database name. The database name provided is either invalid or currently in use."
 

Hey there, I have a problem appending a new field to my database.
I built a function that takes a string from my database I'm appending to, and gets a string from anouther database that I need to be the value in my new Field... I get a error on my "task.AppendField field" saying there is a syntax error
 
 
Option Explicit
Dim LedgerTransaction As Object
Dim LTRecordSet As Object
Dim LTRecord As Object
Dim EntryTypeDescription As String
Dim ColumnName As String
Dim Number As String
Dim LTtask As Object

In Row 1 we have the closing balance
In Row 2 we will be using the closing balance of Row 1 as opening balance + Purchase - consumption = Closing balance
In Row 3 the closing balance of Row 2 will become the opening balance and this will continue, untill a new item witn opening balance is provided.
 
If we use the get previous formula all the data get freesed in that column and we cannot recalculate the amount in the same column.

We have frw isea script in .exe format, however the original .iss script is not available and we need to0 make some modifications to the original script.
Is there any way we can get the original .iss script from the .exe file created using ideascript.

Hi Brian,If i want get a cells value & then add it to the preious cell and keep on populating a column like that. Would it be possible ? For eg. in MS Excel, the same formula would like this = Coln A | Coln B| Coln C| 12               2             22               4            coln C = 12 + 4 = 16  ----- i.e.

Hi
Thanks in advance Brian for your help.
My problem is that because of my regional convention (Argentina), we use the period "." as the thousandth separator and the comma "," as the decimal separator.
When I try to read a format that the decimal separator is a point ".", The numerical reading generates an error and leaves its value at zero.
How can I cast or modify the code so that this reading is correct for my regional configuration?
 
 

Hello,
I am sure this has come up before but does anyone know how you can put a for loop similar to C++ but in IDEA code? I am trying to have a portion of my macro run through the same code over and over again until a final database is formed that doesn't have any outputs.
Any guidance would be much appreciated.
Thanks!
-Claressa

Hi everyone.

I'm sure this must be a relatively straightforward, but wonder if someone could help with the below.

I have an ODBC import script, which performs various pieces of analysis, then exports the results.

Hey guys,
I've got the following task:
In order to check bookings, I created the macro, that does everything I need it to do.
The tables I run the macro on, always have the same structure. My problem is with the file names - they always have a time stamp in their name, from when they're downloaded.
I'd like to automate the macro, so that they can run on any file without having to rename the files everytime.
The file names look like this:
 
YYYYMMDDHHMMSS_SP1_ABCD
 

Hi,
I wanted to see if there is a quick way to copy everything I already put together in this dialog and paste it into another idea script project?
 
Or if there is a way to generate the code that contains that dialog and copy and paste it into the script of the new project?