Mysql

Decimal(5,3) in Mysql is always 99.999

The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]

VB Script

How to Create document using VB Script

To create a document using VB script you need a text editor and use the below code. VB script must be ended by using .vbs VB script runs only on Internet Explorer browser. <script type=”text/vbscript”>Set word = CreateObject(“Word.Application”)Set ActiveDocument = word.Documents.Add()ActiveDocument.TypeText “My first document”ActiveDocument.TypeParagraph()ActiveDocument.SaveAs(“c:sample.doc”)</body></script>

Bonitasoft

How to Set up BonitaSoft BPM with Tomcat and Mysql

Before setting up Bonitqasoft you need following: 1. Latest version of Bonita Open Solution Tomcat and Mysql Bundle.2. Java 1.6 version and set JRE_HOME and set JAVA_HOME system variables.3. Mysql database. Follow below steps to configure BonitaSoft with Tomcat and Mysql : 1.  Create two databases named bonita_history and bonita_journal. Commands: Create database bonita_history;Create database bonita_journal; Step 2. Create user […]