Dec 012014
 
Remove Table and Keep the Text in Microsoft Word

Many times in Microsoft Word document it is required to remove the table that you have created without deleting the text. Ordinary you do so by coping and pasting the text out of the table. The task consumes time if there is more number of rows and columns in a table. The easiest way is

[Read More]
Nov 252014
 

Built-in Subprogram is divided into two categories: Restricted Built-in Subprograms Unrestricted Built-in Subprograms Restricted Built-In Subprograms: Restricted built-in affects navigation in your form either external screen navigation or internal navigation. You can call these built-ins only from triggers where no internal navigation is occurring. Restricted built-ins cannot be called from the Pre and Post triggers

[Read More]
Nov 212014
 

In many scenarios’ you required to convert column data into Delimited (comma or pipelined) separated values into rows in SQL. Follow following two examples step by step to convert column data into row with Comma and Pipelined separated values. Column to Row Data with Comma Separated Example 1: Convert column data into row with Comma Separated

[Read More]
Nov 192014
 

In order to find missing numbers from a series in oracle follow following steps: Step 1: Create one “TEST” table with single column “A”. Create table test (A number); Step 2: Insert few random numbers into “TEST” table. insert into test values (3); insert into test values (7); insert into test values (8); insert into

[Read More]
Nov 172014
 

SQL query to fetch Day from date in Oracle [Suppose Date Time Field value is “17-Nov-2014 15:35:26”] Query to fetch day from date: select extract (day from to_date(’17-Nov-2014 15:35:26′, ‘DD-MON-YYYY HH24:MI:SS’)) “DAY” from dual; Output: DAY 17   SQL query to fetch Month from date in Oracle [Suppose Date Time Field value is “17-Nov-2014 15:35:26”]

[Read More]
Nov 172014
 
Easy Way to Detect USB Flash Drive in Windows

Sometimes laptop or desktop USB ports stop detecting your USB devices like pen drives, dongles etc. This is because your USB ports have been disabled. The usual solution to this problem is to manually re-enable the USB ports by altering the properties of the relevant registry keys. Follow following few steps to enable your USB

[Read More]
Nov 052014
 

  Many times it is required to fetch data in a hierarchical form. The result can be fetched using Recursion. Recursion means self-reference. To explain it in a better way look at the following example: Step 1: Create “Category” table with 3 columns, ID as Primary key, Name and ParentID that references ID column of

[Read More]
Nov 042014
 
Recall and Replace an Email Message in Microsoft Office Outlook

Many times at work we usually send incorrect or incomplete emails without attachment through Microsoft office outlook to our colleagues or higher level management. It feels ashamed like by writing the text “Sorry, Please ignore my mail”. Instead, Microsoft Office Outlook has an inbuilt feature to “Recall and replace a message” or just “Recall a

[Read More]
Nov 032014
 

Input Items are those items that accepts user Input. Input items enables insert, update, delete or query an item process. Types of Input Items: Check Box: Check Box is a two-state interface object that indicates whether a certain value is Checked or unchecked. Trigger associated with check box is WHEN-CKECKBOX-CHANGED. WHEN-CHECKBOX-CHANGED: This Trigger fires whenever

[Read More]