Calendar

March 2010
S M T W T F S
« Feb    
 123456
78910111213
14151617181920
21222324252627
28293031  

How To Connect a Baan Company to Remote Oracle Database

When the Baan ERP went live for years, it’s time to worry about the data growing and cleaning. The administrators will sooner or later receive calls such as why the reports take ages to print out, why the backup takes longer and longer, etc. In Baan, there is an ability to shrink your live data [...]

Baan ASCII Functions

Last week I was asked to verify the item description to exclude certain characters and to limit the first character with 0-9 and A-Z. As some of the characters such as double quote (“) and semicolon (;) can not be easily used in the expressions, I finally decided to use the value of ASCII alternatively.

There [...]

Baan Functions – String searching or comparing (pos)

Recently I was involved into a small data verification project, which identified certain characters in Item Code and set certain limitation for it. As we may know, it is quite easy to use such functions as LEFT/RIGHT/MID to take specific characters out of a string. But in Baan, none of similar standard function is available.

Luckily, [...]