IDEAScript Questions
Get long record value
Forums
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
- Read more about Get long record value
- 3 comments
- Log in or register to post comments
Define Action Field - Run Script and define parameters
Forums
Is there way to run an IDEAScript through define action field and specify parameters (using contents of field or user defined text) using IDEAScript?
Screenshot Attached to see what I mean
Scott
Extracting blank records in a file
Forums
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
- Read more about Extracting blank records in a file
- 3 comments
- Log in or register to post comments
Create Pivot table from Ideascript
Forums
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?
- Read more about Create Pivot table from Ideascript
- 9 comments
- Log in or register to post comments
Dialog Boxes
Forums
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!
- Read more about Dialog Boxes
- 8 comments
- Log in or register to post comments
Browse windows to select item
Forums
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
- Read more about Browse windows to select item
- 8 comments
- Log in or register to post comments
How to compile a script
Forums
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.
- Read more about How to compile a script
- 1 comment
- Log in or register to post comments
Hide Fields
Forums
Hi!
May I know if there is a way to hide fields?
p.s I have appended a field and if i were to use remove field function it would return an error
- Read more about Hide Fields
- 2 comments
- Log in or register to post comments
IDEAScripting with Dialogs
Forums
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)...
- Read more about IDEAScripting with Dialogs
- 11 comments
- Log in or register to post comments
Get data from Edit Input Box
Forums
Hi, I am very new to programming and would like to know how i can use data being entered into edit input boxes in my code.
- Read more about Get data from Edit Input Box
- 8 comments
- Log in or register to post comments