IDEAScripting.com update
Hello everyone,
As some of you might have noticed the site has been down for that past month or so. The main reason was that the site needed a major refresh and the platform that I was using to create the site was nearing its end of life. Unfortunately, the platform had been rewritten since I had created the site so there was no easy upgrade path, that is why it has taken so long as there was lots of trial and errors on my part to get the site up and running with the latest software.
- Read more about IDEAScripting.com update
- 3 comments
- Log in or register to post comments
Timer
Code to time your script.
- Read more about Timer
- Log in or register to post comments
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.
- Read more about Array to hold all Field Information
- Log in or register to post comments
Populate Select List Based on Drop-Down Selection
This is a demo program on how you can populate a list box based on a selected field.
Example of populating drop-down based on contents of previous drop-down
This demo script will show you how to populate a drop-down based on the contents of the previous drop-down. In this example it will take the contents of the field t
Extraction Based on Date
A small script that allows you to do an extraction based on a date. This script has been rewritten in Python.
- Read more about Extraction Based on Date
- 6 comments
- Log in or register to post comments
Generate Audit Number
This script will create an number field that keeps a count based on the selected field. When the contents of the field change it resets to 0 and starts the count over. There is also a second script that will order the field based on a date field.
- Read more about Generate Audit Number
- 9 comments
- Log in or register to post comments
Split Text File
This script will split a text file into smaller sections.
- Read more about Split Text File
- Log in or register to post comments
Date Creation Database
This script will create a date database based on a start and end date. The script can do all date or the beginning or end of the month.
- Read more about Date Creation Database
- Log in or register to post comments
Add Prefix-Suffix to Field Names
This script will allow you to add a prefix or a suffix to all your field names. This is great when performing a join or Visual Connector and don't want the entire file name to be included.
- Read more about Add Prefix-Suffix to Field Names
- 2 comments
- Log in or register to post comments