Welcome to Milindanath's Blog

What are the basic Object Oriented Concepts?

* Abstraction
* Encapsulation
* Inheritance
* Polymorphism

posted by Milindanath @ 11:02 PM 0 Comments

What are DML and DDL in SQL

DML - Data Manipulation Language
DDL - Data Definition Language

DML
SQL executes queries (select), update, insert and delete records of a database.These actions of SQL form the DML.
DDL
DDL part of SQL permits to create,delete or change database tables. In addition we can create indexes(keys), specify links between tables and add constraints between tables.
-CREATE TABLE
-ALTER TABLE
-DROP TABLE
-CREATE INDEX
-DROP INDEX

posted by Milindanath @ 10:55 PM 0 Comments

Variable Types in crystal reports

There are 3 levels of scopes for variables in crystal reports.
1. Local
2.Global
3. Shared

Local Variables
Declaration: scope TypeVar variablename;
Ex: Local NumberVar x;

*this type of variable can be only used within that formula. Can't access from another formula.

Global Variables
Global variables can be accessed by any formula in the main report. but sub report formulas can't access.
* by default in crystal variables are global.
ex; Global StringVar y;

Shared Variables
Shared variables can be accessed in the main report and also in the sub reports.
Declare it in the main report.
Ex: Shared NumberVar x:=1000;
Before passing the shared variable to a sub report it should be declared and assigned a value as above.
use it in the sub report as follows

Shared NumberVar x;

posted by Milindanath @ 10:42 PM 0 Comments

Examples of using HTML frames

Set 3 vertical frames in one browser window
<frameset cols="25%,50%,25%">
<frame src="frame_a.htm"> <frame src="frame_b.htm"> <frame src="frame_c.htm">
</frameset>

posted by Milindanath @ 3:33 AM 0 Comments

Sql vs oracle

How to convert a date figure to a string in sql and oracle

sql ------------------>CONVERT(varchar, Column_DATE, 103) AS [Application Date]
oracle---------------->to_char(Column_DATE,'dd/MM/yyyy') "Application Date"

posted by Milindanath @ 1:55 AM 0 Comments

Milindanath

posted by Milindanath @ 8:13 AM 0 Comments