Author's posts
Mar 11
LSMW recording vs BDC recording
LSMW RECORDING The LSMW recorder is much simplified when compared to the SHDB recorder: It always start with default options (update mode A, no default size, use BDC mode (SY-BINPT is ‘X’), do not simulate background mode (SY-BATCH is space), and SY-CALLD is set to ‘X’). In LSMW recording, BDC_OKCODE and BDC_CURSOR fields cannot be …
Permanent link to this article: https://blog.openshell.in/2011/03/lsmw-recording-vs-bdc-recording/
Mar 03
Replace Special Characters Using Java
Using Java, have you ever been tried to replace all special characters in a String? Here is the fine example of replacing all special characters in a String using replaceAll() method. It also discusses about the difference between replace and replaceAll methods of java.lang.String class.
Permanent link to this article: https://blog.openshell.in/2011/03/replacing-special-characters-using-java/
Feb 26
Adding dynamic controls in Asp.net
1.Declare public variables static DropDownList[] drp_arr; static int drp_count; 2.Write methods to develop dynamic controls protected void add_dropdown(DropDownList drp) { try { //add to a container on the page pnltitle.Controls.Add(drp); //add a spacer after the control pnltitle.Controls.Add(new LiteralControl(“<br><br>”)); } catch (Exception ex) { } } private void createdropdown() { try { for (int i = …
Permanent link to this article: https://blog.openshell.in/2011/02/adding-dynamic-controls-in-asp-net/
Feb 21
Excel to MySQL
Usually MS Excel provides many options to import data from other sources like XML or using data source. Now, the data from excel file has to be exported to a form which MySQL could read and insert into existing relational tables. You can think about .sql file. Usually, MySQL tables can be imported by SQL script (.sql) files. SQL script file contains the DDL and DML queries. But in our case, we need to load the rows of excel file into a table.
Permanent link to this article: https://blog.openshell.in/2011/02/excel-to-mysql/
Feb 14
The Project Team – Funny Quotes
I Got this Funny Quotes via Forward mail. But it is basically 100% true , even though described in as a funny way. See: 1. Project Manager is a Person who thinks nine Women can deliver a baby in One month 2. Developer is a Person who thinks it will take 18 months to deliver …
Permanent link to this article: https://blog.openshell.in/2011/02/the-project-team-funny-quotes/
Feb 14
Augmented reality – 6th Sense
Amazing Video Watch this amazing presentation. It is really Amazing. It has been Presented 2 years before itself.
Permanent link to this article: https://blog.openshell.in/2011/02/augmented-reality-6th-sense/
Feb 14
Warning before navigate away from a page
In some cases, if you are in between any work of editing or typing a content, and you wont let the visitor to navigate away from the page without particular condition, say the document is not saved yet, you can block the navigation (even the closing of the browser window) with Javascript. Code: window.onbeforeunload = …
Permanent link to this article: https://blog.openshell.in/2011/02/warning-before-navigate-away-from-a-page/
Feb 14
jQuery Traversing Tips
Just a quick review of tips available in jQuery to manage nodes (contents) near by the content / node which is triggered an event like click, hover etc Functions: find, parent, parents, children, first, last, closest Suppose you need to manage some nodes nearby a link or a button on an event. Say $(‘.button’).click(function(){ // …
Permanent link to this article: https://blog.openshell.in/2011/02/jquery-traversing-tips/
Feb 04
Network Address Translation(NAT) or Port Forwarding
hi dear, This article is not made for technical person though if you are a network kiddy or if you are searching for a startup on NAT this article is a good place to start. I assume you might have knowledge of public ip and private ip if not click here. Network Address Translation(NAT) or Port …
Permanent link to this article: https://blog.openshell.in/2011/02/network-address-translationnat-or-port-forwarding/
Feb 01
IBM DB2 CLP Help System
Target Audience: DB2 Developers DB2 developers may feel exhausting time when working with CLP when accessing help documents. IBM DB2 enables CLP help reference (like MAN in Unix/Linux). When SQL query is processed, in case of any failure DB2 returns the error using SQL codes. In CLP interactive mode type the following command to get help reference …
Permanent link to this article: https://blog.openshell.in/2011/02/ibm-db2-clp-help-system/