Skip to main content

IDEASnippets

Array to hold all Field Information

I use the Type procedure that allows you to create a user-defined data type containing one or more elements.  I create an element for each of piece of information that is contained in the field then I use this type as an array and populate it with all the field information.  This is an easy way to get all the information on the fields in a database in a quick manner.

renameFields Function

Function: renameFields
Purpose: To rename fields within a file
Input:    sTempFilename: the name of the imd file that contains the fields to change
             sOldFieldName: The name of the field that is to be changed
             sNewFieldName: The new field name
Returns: True if fieldname was changed False if the field name could not be changed
Problems: Currently does not work for some Editable fields

Date Picker

One of the items that the IDEAScripting dialog lacks is a date picker.  I recently saw a post on the IDEA forum that they had the script for one but for some strange reason weren't releasing it on the scripting section, so I decided to try and create a date picker for my use and anyone else that wants to use it.

The attached script has the code for the date picker along with an example of how to use it with a dialog that asks for the user to enter a date.

When you start up the example script you will have a dialog with two edit boxes where the user can enter a date: