IDEAScript Questions

I got a bank transaction file in which only the bank statement number is a field. If i want to join this file with the administration i need to have the row/record number in a field so i can create a key field on which to join on. 
Question 1 is how can i create a field with the row number and question 2 is how do i make it that when the field with the bank statement number changes the row number starts with 1. In the perfect world it should looks like this:
Bank statement nr.      Row number

Hi, i want to use the fieldsname which i placed in an array to check for each field if it is numeric or not. But for some reason it won't accept the array fieldname to get the field and check if it is numeric or not. Anyone who can help me?
 
------------------------------------------
 Option Explicit
 
Dim A1 As Integer
Dim A2 As Integer
Dim i As Integer
 
Dim DbLetter As String 
Dim Q1 As Integer
Dim Q2 As Integer
 
Dim db As database
Dim table As table

Hi Brian, is there a way to add text into an existing blank field, using a script. I've seen some scripts to fill down a column with the contents from the previous field, but i need to add new text to the blank fields.
 
For example, i have a database with various columns and 1000 records. In column X, 500 fields allready has text Q1, the other 500 fields are blank. In these blank fields I want to add Q2.
 
Thanks, Mike

My name is Lucas and I'm from Argentina, I really like your blog.
 
I have a query, I'm doing a "macro" for IDEA with visual basic, where from a base I take a field that has a date in string format I convert it to date. Then I want the user to enter a date with which to compare that data previously obtained, in order to have the base already filtered.
 
Sorry for my english.
 
I have made the following script:
 
' File - Import Assistant: Delimited Text
 
Function Test
dbName = "E070.IMD"

Hey everyone,
 

Hello everyone,
 
For some stupid reasons I need to be able to copy a database from the IDEA Server to a local IDEA project. However I cannot find any informatie on how to do this and the IDEAScript helper is useless. I am looking for a bit of code expecting something like task.CopyDatabase("database name", "Destination folder") a bit like the task.MoveDatabase command but I need it to be a copy and it has to be from the server towards a local project. Please help me out!
 
With Kind Regards
Ivo
 

Good afternoon Brian,
Love the website, thanks for your dedication to it. I am trying to utilize a variable that I created from the Field Statistics to  count the number of records. However when I put the variable in the Field.Equation line, I recieve a "0" instead of the number of records. The first attachment is the script piece, the second attachment is the results in the databas, where there are "0"s I was expecting the Recordnumber count from the variable RecordCounterResult.
 
Additional Info:

At the moment i'am using the On Error Resume a lot, but is it possible when the err.number is not equal to 0 that a text line is exported to a txt file? That way i can create a log. Because with the automate of IDEA server scripts i can't use msgboxes anymore.

Is there a basic script to check if a database file in a IDEA server project exists? And is there a script to check if a field in a database exists?
At the moment i'am scripting for IDEA server projects and if i want to automate scripts there can't be any popup boxes or message boxes in the script but this leads to a world of problems. Anyone with any experience in scripting on IDEA server projects and automate scripts?