Skip to main content

IDEAScript Questions

Get long record value

Hello
you know if there is any way to get a value from a field that is numeric, but it is very large and you have to bring it as long.
For Example exist types of Get Value

  • ActiveRecord.GetCharValue
  • ActiveRecord.GetNumValue

But ActiveRecord.GetLongValue don't exists
My Code:
MontosValor = RS.ActiveRecord.GetCharValue("MANUALESMONTO"))
Help, Thanks
 
 

Extracting blank records in a file

Hi all
 
I have built a script that extracts blank records from each field in a file. It is running without any error but it is not creating the extracted database.
The script is as below. Please help, thanks.
________________________________________________________________________________________
Sub Main
 
'Variable declarations
 
'Database objects needed from active DB
Dim NumFields        As Integer
Dim olddb    As Object
Dim task    As Object

Create Pivot table from Ideascript

I am new to scritpting and have been utilizing history to create most of my scripts. I wanted to try and script to create a pivot table but unfortunatly when you create a pivot table there is no history to review. Is there a snippet or could someone share an example of how to create a pivot table in ideascript?

Dialog Boxes

Hi, I am back once again. Have been working on the script and its been smooth with serveral ups and downs.
The current issue I am facing is that I cannot seem to store information within an object and I have the same error coming back to me each time.
My Dialog box's name is NewDialogX
sFieldName = listBox1$(NewDialogX.DialogBoxDropListBox2)
 
Error : Invalid Qualifier
If I were to remove NewDialogX the code runs but no information will be store in sFieldName.
p.s I ran a message box right after this.
 
Cheers!

Browse windows to select item

Hi Brain, 
 
How are you doing? can you help me with a bit of script? I'm trying to get browse window to select a file. I already found a bit of script that lets you select a folder, but i need to select the file. I'm having problems converting the script to let me select a file instead of a folder.
 
Function BrowseFolder() Dim oFolder, oFolderItem Dim oPath, oShell, strPath, item Dim msg As String

How to compile a script

Hi folks,
 
Hoping you can help as I'm struggling to get this script to run and being fairly new to scripting (I've only compiled a couple before), I was hoping to get some help on what I'm doing wrong.
 
I've attached the script I'm trying to run, which is a composite of all the IDEA scripts for each stage of the process I want to automate. The problem I'm having is is keeps telling me I haven't defined my database names; I tried to do this using Dim but it still didn't work no matter what I entered so I removed it.
 

IDEAScripting with Dialogs

Greetings! (edited)  This is my first post after a year being a member.
I am working in a yearly project and because of that I programmed everything in IDEA.  My Project Manager asked me to program everything in a way that anyone, with little IDEA knowledge, can run it.  I have many IDEAScripts that I wrote to perform all the analysis.  Now I added dialogs to make it easier.  Everything runs great without errors. Almost perfect! But (there's always a but)...