IDEAScript Questions

Hi,

Hello, 
I have a set of data that has an assigned account number. I would like to select from this data a sample, but I wish to not select more than 5 items with the same account number. 

Hi again,
I was looking for method, how to hide a field, but I found only one similar thread on this forum, but without an explanation which commands to use.
Assuming I have a database "db.IMD" and I want to hide field "CHAR1"
Function hide(dbase As String, fieldname As String)
Dim db As database
Set db = client.OpenDatabase(dbase)
.....Something like db.HideField(fieldname)???
End Function
 
Many Thanks
Anre

Hello, 
I've written a set of functions within a single script that completes various tasks. Each function has its own error handler with the intention of logging which function the error occurred so I can quickly isolate a potential problem to one single function. However, during my testing I've noted that when an error occurs in one of the functions it calls the error handler in all of them. Is there a way to fix this or perhaps build a single error handler for the whole script that will log from which function the error originates. 

Hello, I was an Excel user before, but have started to work with IDEA for a while. First of all sorry if will use such definitions as "cells" etc. I have a database, it looks like
UserName | bla | bla2| bla 3| .....
Superman | 1     |   2   |    3    |  .....
Hyperm_n | 4   |   5    |    6    | .....

Hello, 
I'm having a little problem when trying to delete a database using Script. Everytime the code run it gives me an error saying: "Unable to delete." Not sure why that is, so any help would be great. 
Code I have is: 
Client.DeleteDatabase("SumbyJrnl.IMD")

Hello,
Part of a script I am working on includes a direct extraction.  I want to close both the original database and the extraction database once the extraction is complete.  I added Close but that only closes the extraction database (script attached).  I also tried Close All but obtained the same result.  My apologies if this answer exists somewhere on your site already.  I tried several searches and wasn't able to find it.  Thank you very much!  
Holly
 
 

Is it possible to generate a table preview window by idea script?

Hi,
I am fairly new to IDEA script, and I am trying to modify a macro so that it will import two new files monthly that we receive from another department.  The file names are the same except for the date at the end which is why I have tried using an input box that you can see in part of my script attached.  I am getting many syntax errors and am having trouble working around them.  Is there a better way to go about this?
 

Hello everyone,My file contains the number of tickets sold, the ticket price, type of payment, type of transaction, type of ticket and the date of the transaction.Using IDEAScript, I would like to produce 6 different tables showing the number of tickets and the enti