Last week I wrote a new version of my custom function FrontTabs. The function retrieves the object names of all open tabs. Another developer discovered an error in the previous version. With three or more nested tab controls the function could return a wrong result. It was time to rewrite the function. The new version takes care of that problem.

The function FrontTabs returns a list with all currently open tabs, so called front tabs. Of course, all tabs must have an object name. The returned object names are listed in the order of the nested tab controls, starting with the utmost tab control. This makes it easy to recreate a previous saved front tabs status. Read more …

June 9th, 2010

As a developer you might need a timer in your database. In that case you might find this feature helpful. You can create timer, as many as you like. Use them for benchmarks, to log import and export times, or to keep track of user log-in times.

Stop Watch

Each timer works like a little stopwatch. You can …

  • start it,
  • stop it,
  • restart/stop it again,
  • read the elapsed time,
  • and reset/remove it.

This is accomplished with custom functions and a global variable:

  • timer( name; action )
  • param( key; value )
  • param.get( key; params )
  • param.delete( key; params )
  • $$timer

Read more …

This article is part of my series Custom Function Vault. Here I describe miscellaneous custom functions to verify required script parameters.

  • param.script.check()
  • text.between( text; start; end; type )
  • trim.all( text; trimChr )
  • var.assign( definition )

Read more …

June 24th, 2009

This article is part of my series Custom Function Vault. Here I describe a custom function for working with parameters.

  • param.assign( params )

Read more …

June 24th, 2009

This article is part of my series Custom Function Vault. Here I describe custom functions for managing (script) parameters.

  • param( key; value )
  • param.get( key; params )

Read more …