Hifni Shahzard Nazeer

How to configure OracleXEClient to connect to OracleXE?

2012-02-02T15:02:00.000+05:30

1. Create a new user Variable called “TNS_ADMIN”
Assume ORACLE_HOME of XE is in C:\oracle\product\oraclexe
Since when you install Oracle 10g Express Edition, a tnsnames.ora file has already been created for you in C:\oracle\product\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora
Either set TNS_ADMIN in DOS prompt or in a New User Variable
You can set TNS_ADMIN to your local path of Oracle Express Database
set TNS_ADMIN= C:\oracle\product\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora
or you can copy tnsnames.ora from C:\oracle\product\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora to C:\oracle\product\XEClient, and set TNS_ADMIN in the User Variable

Click on [Start], Programs, Oracle Client 10g Express Edition, Run SQL Command Line
SQL> connect sys/ora10g_manager@xe as sysdba

Other ways to connect to Oracle Express in DOS prompt

Method 1:
Set TNS_ADMIN in DOS prompt
In DOS prompt,
C:\> set TNS_ADMIN=C:\oracle\product\XEClient
C:\> C:\oracle\product\XEClient\bin\sqlplus.exe /nolog
SQL> connect sys/ora10g_manager@XE as sysdba

Method 2:
No need to set TNS_ADMIN in DOS prompt but enter the full connection string in one line of DOS command
Set NLS_LANG in DOS Prompt
C:\>set NLS_LANG=English
Enter the following DOS command all in ONE line
C:\>sqlplus "sys/ora10g_manager@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))) as sysdba

Source: https://forums.oracle.com/forums/thread.jspa?threadID=576930

Default Values via BindingSource's AddingNew Event

2011-07-21T10:41:00.003+05:30

I new that BindingSource's AddingNew event can handle all default value assignment, but was so frustrated that I could not find any articles/tutorials which guided me on how to use it. Although MSDN had description, but it did not have samples on how to use it. However, with few long hour searches I came to a source which enlighted me on how to use this event.

A sample code looks like this:

private void branchBindingSource_AddingNew(object sender, AddingNewEventArgs e)

{

//// Get data table view

DataView dataTableView = branchBindingSource.List as DataView;

//// Create row from view
DataRowView rowView = dataTableView.AddNew();

rowView["BranchID"] = -1;

rowView["BranchCode"] = "001";

rowView["BranchDescription"] = "002";

//// Set New row

e.NewObject = rowView;

branchBindingSource.MoveLast();
}

source: http://devexpress.com/Support/Center/p/Q96282.aspx

Opening a Solution Causes VS 2005 to crash and restart

2010-10-28T16:35:00.003+05:30

Earlier today, I had to include a code snippet to my project. Unrealizing the consequences it might result in, I went ahead compiling and got an error message saying “Object reference not set to an instance of an object” and finally my VS 2005 crashed. This error message keeps on greeting every time to I tried to reopen the project.

Being clueless of what has gone wrong, I googled tirelessly to find a solution to overcome this problem, but without a joy.

While this error message keeps on coming, I try to realize that my VS were actually running on debugging on all of my Windows forms. Since the Code snippet I included was to my base form’s shown event, so every time I reopen VS 2005 it opens this Windows Forms and sends this error message.
In the Error Signature I witnessed the following:

AppName: devenv.exe
AppVer: 8.0.50727.42
AppStamp:4333e699
ModeName: system.design.ni.dll
ModVer: 2.0.50727.3053
ModStamp:4889df30
fDebug:0
Offset: 006b8532

I came across an article on running devenv.exe in “Visual Studio 2005 Command Prompt” and was enlightened me that I could build, rebuild, clean…etc project and its files. So I went to Visual Studio’s Project folder and located the *.cs file which was giving the error and edited via Notepad. Then I deleted the code snippet that was the causing the problem and replaced by a simple “Hello World” message box. Finally I build the project by trying my luck via VS 2005 Command Prompt by running the following commands:

devenv [either *.csproj or *.sln file of your project] /clean

devenv [either *.csproj or *.sln file of your project] /build

devenv [either *.csproj or *.sln file of your project] /rebuild

and it worked! I was finally able to open the project via Visual Studio and it worked well… No errors!

Wrestlemania 26: I made it!

2010-04-06T18:08:00.001+05:30

I could only imagine myself being in Phoenix and yelling at 72,000+ people saying that I’ve made it!
Though I could not make it realistically, I’m at least glad that I got the DVD of it which I repeatedly saw it many times so far and even gave a torrid time to my DVD player by hitting the rewind button more often.

Although bit disappointed that the Rated-R could not claim the World Heavyweight championship, but he did not disappoint any by delivering a special kind of a “Spear” to Chris Jerico. I heard some one say it’s the “Edge-de-cution”. However I’m more than assured that the glory is not far away for Edge. Wish you all the best!

The viper was never far away from the show; however he delivered the ideal, if not the best RKO to finish things off with Legacy. I reckon that it’s the best I have ever seen in my bare eyes.

John Cena Vs. Dave Batista was more intense…. And ultimately it’s the never give up attitude that changed the course of the match. I was just astonished to see the US Navy performing a special performance before Cena enters to the ring. My memory diverts to the Wrestlemania 25. . In fact the “Attitude-Adjustment” he delivered was still in my minds.

Coming to Shawn Micheals, I never thought the Odds favors him, yet it was almost the identical Wrestlemania 25 match. Never the less both gave an exceptional performance and Sportsmanship of Undertaker should be admired a lot.

The intensity was awesome and all I could say that Wrestlemania keeps getting better and better. Can’t hardly wait to see Wrestlemania 27… and If god could send me to Atlanta next April I’ll consider it as just a miracle that happened.

Master/Detail Updation: Reflecting Identity Value

2009-08-18T11:08:00.006+05:30

Master-Detail is quite easy to explain, but its complexity lies when you’re implementing it particularly when the identity columns rely on database given values. Researching on this topic for several months, days and hours, finally things lightened up for me.

Instead having to rely on an auto increment value, I have to rely on a value set provided via trigger. Have to admit myself that the resource below was very helpful indeed to the quest of solving this problem:

http://www.eggheadcafe.com/forumarchives/NETFrameworkADONET/Nov2005/post24232248.asp
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/thread/4d10fe87-2de8-42a8-8ef9-b9d46c0fd28d

The environment I was working with was Windows XP Pro SP+3, Visual Studio 2005, C#.net, Oracle XE DB, Oracle 10g client, System.Data.OracleCleint and TableAdapters;

To illustrate how I went on, I extracted the following tables from my project:

Journal(journalid*, xsactdate, xsactdesc);
JournalAccount(Journalid*, accountid*, xsactvalue);
PKEY(journal_PKEY);

I had the following triggers written for the Journal & JournalAccount table respectively.

DECLARE
nJournal_PKey PKey.Journal_PKey%TYPE;
nChkJournalID Journal.JournalID%TYPE;
BEGIN
-- this is to prevent posted Journals from being updated
IF ( INSERTING ) THEN
nChkJournalID := :new.JournalID;
ELSE
nChkJournalID := :old.JournalID;
END IF;

BEGIN
SELECT JournalID INTO nJournal_PKey FROM AccountLedger WHERE JournalID = nChkJournalID and rownum = 1;

IF ( SQL%FOUND ) THEN
RAISE_APPLICATION_ERROR( -20000,
'This transaction has been already being posted to the ledger '
'insert/update/delete not allowed'
);
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL;
END;

IF ( INSERTING AND (:new.JournalID IS NULL) OR (:new.JournalID < journal_pkey =" Journal_PKey">

Having followed what David Sceppa and Jason Kresowaty alias BinaryCoder wrote in their postings, things were going ok for me, except for the fact that Identities aren’t reflected upon saving to the table. Since the TableAdapters created without the InsertCommand, I have to include it by myself. There were certain things which I need to modify, particularly Insert Query. Look into my Insert Query and you may see the Oracle Keyword “RETURNING”. The keyword is basically enables us to use it as an output parameter. I have inserted the temporary identity and getting back the value assigned via the trigger as an output parameter.

The following describes the “RETURNING” clause of Oracle: http://www.myoracleguide.com/s/Returning.htm

Finally have to amend the System.Data.DataRowVersion to System.Data.DataRowVersion.Proposed and the identity field (JournalID in my case) System.Data.ParameterDirection to System.Data.ParameterDirection.InputOutput.

The following is the InsertCommand in the TableAdapter for the Journal Table:

this._adapter.InsertCommand = new System.Data.OracleClient.OracleCommand(); this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO JOURNALACCOUNT(JOURNALID, ACCOUNTID, XSACTVALUE, DISCOUNTEDPAYMENT) VALUES (:JOURNALID, :ACCOUNTID, :XSACTVALUE,'N') RETURNING JOURNALID INTO :JOURNALID";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("JOURNALID", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.InputOutput, "JOURNALID", System.Data.DataRowVersion.Proposed, false, null));
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("ACCOUNTID", System.Data.OracleClient.OracleType.Char, 15, System.Data.ParameterDirection.Input, "ACCOUNTID", System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("XSACTVALUE", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.Input, "XSACTVALUE", System.Data.DataRowVersion.Current, false, null));

The following is the insertcommand in the tableadapter for the JournalAccount table:

this._adapter.InsertCommand = new System.Data.OracleClient.OracleCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO JKSBSCHEMA.JOURNAL(JOURNALID, XSACTDATE, XSACTDESC) VALUES (:JOURNALID, :XSACTDATE, :XSACTDESC) RETURNING JOURNALID INTO :JOURNALID";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
this._adapter.InsertCommand.UpdatedRowSource = System.Data.UpdateRowSource.Both;
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("JOURNALID", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.InputOutput, "JOURNALID", System.Data.DataRowVersion.Proposed, false, null));
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("XSACTDATE", System.Data.OracleClient.OracleType.DateTime, 7, System.Data.ParameterDirection.Input, "XSACTDATE", System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new System.Data.OracleClient.OracleParameter("XSACTDESC", System.Data.OracleClient.OracleType.VarChar, 40, System.Data.ParameterDirection.Input, "XSACTDESC", System.Data.DataRowVersion.Current, false, null));

Refer My Post @ MSDN Forums: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/thread/fbfdc09b-41bf-4290-9dea-6a9a85d5becf

The Banker Quote

2009-07-05T17:32:00.003+05:30

While browsing the internet, I came up with an interesting quote by Mark Twain which apparently was highlighted under an individuals signature. Check this out:

A banker is a fellow who lends you his umbrella when the sun is shining, but wants it back the minute it begins to rain.
Mark Twain (1835 - 1910)

ORA-06502: PL/SQL: numeric or value error

2009-04-10T10:46:00.002+05:30

This error was a real nightmare for me where I'm being in middle of a migration process of our legacy system. Though there was real hits when you google this problem, but nothing was helpfull for me.

The context of the problem occurs when I did run it on a WinXP pro sp3+ workstation which had installed the latest ODP.NET. However its quite extraordinary to see it was not reproduced in a machine installed Oracle Express Edition 11g (without oracle client).

Later, I understood that this problems occurs if you have a VarChar2 parameter(s) when executing a Oracle Stored Procedure. So people advised to have the size and Parameter direction in the parameter. I incresed the size everytime of the parameter and had the parameter direction as "input", yet this error kept bugging me. (My stored procedures did not have any return/output parameters, so I'm not in a possition to comment its behavior).

Finally after googling for days and finding one post in the Oracle forum from one guy who said to use the direction as "InputOutput" did the work for me. Furthermore to the parameter direction, I also gave all of the VarChar2 parameter size as 2000.

Produced Environment: .NET framework 2.0, Win XP Pro sp3 and the latest ODP.NET

Motivation

2008-09-01T17:24:00.002+05:30

When the road you're trudging seems uphil,
When the funds are low, and debts are higher,
And you want to smile but you have to sigh,
When care is pressing you down a bit,
Rest if you must, but dont quit!

--
Hifni Shahzard Nazeer M. AMBCS
Blog: http://hifni.blogspot.com | Web: http://hifni.shahzard.googlepages.com
"The higher we soar, the smaller we appear to those who cannot fly" - Friedrich Nietzsche

Solutions: Visual Studio.NET 2003 Debugging Errors

2008-08-20T11:01:00.002+05:30

Run the aspnet_regiis.exe via the Visual Studio.NET 2003 Command Prompt ( - Start Menu > Microsoft Visual Studio.NET 2003 > Visual Studio.NET Tools > Visual Studio 2003 Command Prompt - ) to register asp.net into IIS. The aspnet_regiis.exe is availabe in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322. This scenario should be applied when you re-install either IIS or Visual Studio.NET 2003

Also check the <processModel> tag of your machine.config, check the value of <userName> attribute. It could be machine, if so change it to system. Finally restart IIS and retry. Source: http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21547213.html

Further Reference:
http://msdn.microsoft.com/en-us/library/h35f56yz(VS.71).aspx
http://msdn.microsoft.com/en-us/library/dwesw3ee(VS.71).aspx

A Day @ JKSB

2008-06-16T18:13:00.001+05:30

Getting Percentage from SQL Queries

2007-05-24T15:47:00.000+05:30

This is the way I got a Percentage Column in my Query. For this I used Microsoft Access's Northwind Database which is available along with Office Package.

Lets Assume that We need to show all Customer's Total Order Value from Northwind.mdb. For that I used the following Query:

SELECT
Customers.CompanyName,
Sum([UnitPrice]*[Quantity]) AS CustTotal,
FROM
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID
GROUP BY Customers.CompanyName, Orders.CustomerID
ORDER BY Sum([UnitPrice]*[Quantity]) DESC;

I figured that to get the percentage i need to use the following simple formula:

Percentage = [Client Total]/[Overall Total] * 100;

So to get the percentage I added the following SQL which is a translation of the above formula:

(
((Sum([UnitPrice]*[Quantity])/(SELECT SUM([UnitPrice]*[Quantity]) FROM [Order Details]))*100)
) AS Percentage

So the Overall SQL looks something as after add:

SELECT
Customers.CompanyName,
Sum([UnitPrice]*[Quantity]) AS CustTotal,
(
((Sum([UnitPrice]*[Quantity])/(SELECT SUM( [UnitPrice]*[Quantity]) FROM [Order Details]))*100)
) AS Percentage
FROM
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID
GROUP BY Customers.CompanyName, Orders.CustomerID
ORDER BY Sum([UnitPrice]*[Quantity]) DESC;

PLEASE! if you found this interesting, do drop me a comment!

Final Days @ JB Securities

2006-12-14T09:36:00.000+05:30

Me and My friends at JB

My Boarland Delphi 5 Enterprise Edition While loading

MSDE 2000 Issues

2006-12-14T09:02:00.000+05:30

Installing MSDE 2000 is bit complicated thing, unlike in MS SQL Server 2000. There is no user interface and no installation wizard, but you have to use TSQL to all of tasks in the Command Prompt. (Its like going back to the DOS era)

You get MSDE in your Office CD free. I had Microsoft Office XP with me and this is the way I installed it.

Insert your Office CD in, and type the following in your Command Prompt:

C:\>D:\MSDE2000\Setup.Exe SAPWD="" SECURITYMODE=SQL DISABLENETWORKPROTOCOL S=0/L*v C:\MSDELOG.TXT

And to Attach a Database to MSDE, I used the following way:

Again nothing will help you instead of Command Prompt.

Here, first you have to login to MSDE, and this is the way its done (provide your SA password):

C:\>osql/U sa/P

Once logged in, type the following in the command prompt:

EXEC sp_attach_db @dbname='pubs' @filename1='C:\Program Files\Microsoft Sql Server\MSSQL\Data\pubs.mdf' @filename2=''C:\Program Files\Microsoft Sql Server\MSSQL\Data\pubs_log.ldf' GO

Its arent easy with out a proper GUI, yet I was able to surf the internet and get help.

Do you really know how to forward e-mails? 50% of us do; 50% DO NOT

2006-11-01T09:47:00.000+05:30

A friend who is a computer expert received the following directly from a system administrator of a corporate system. It is an excellent message   that ABSOLUTELY applies to ALL of us who send e-mails. Please read the short letter below, even if you're sure you already follow proper procedures.

LETTER TO Everybody : Do you really know how to forward e-mails? 50% of us do; 50% DO NOT.

Do you wonder why you get viruses or junk mail? Do you hate it? Every time you forward an e-mail there is information left over from the people who got the message before you, namely their e-mail addresses & names. As the   messages get forwarded along, the list of addresses builds, and builds, and builds, and all it takes is for some poor sap to get a virus, and his or her computer can send that virus to every E-mail address that has come across his computer. Or, someone can take all of those addresses and sell them or send junk mail to them in the hopes that you will go to the site and he will make five cents for each hit. That's right, all of that inconvenience over a nickel! How do you stop it? Well, there are several easy steps:

(1) When you forward an e-mail, DELETE all of the other addresses that appear in the body of the message (at the top). That's right, DELETE them. Highlight them and delete them, backspace them, cut them, whatever it is you know how to do. It only takes a second. You MUST click the "Forward" button first and then you will have full editing capabilities against the body and headers of the message. If you don't click on "Forward" first, you won't be able to edit the message at all.

(2) Whenever you send an e-mail to more than one person, do NOT use the To: or Cc: fields for adding e-mail addresses. Always use the BCC:(blind carbon copy) field for listing the e-mail addresses.   This way the people you send to will only see their own e-mail address. If you don't see your BCC: option click on where it says To: and your address list will appear. Highlight the address and choose BCC: and that's it, it's that easy. When you send to BCC: your message will automatically say "Undisclosed Recipients" in the "TO:" field of the people who receive it. If that phrase does not appear, type your own email address in the "TO" field, but put everyone else's in the BCC field.

(3) Remove any "FW :" in the subject line. You can re-name the subject if you wish or even fix spelling.

(4) ALWAYS hit your Forward button from the actual e-mail you are reading.

Ever get those e-mails that you have to open 10 pages to read the one page with the information on it? By Forwarding from the actual page you wish someone to view, you stop them from having to open many e-mails just to see what you sent.   (AMEN!)   If you can't forward from that page, "Copy" the info and then open a new email blank page and "Paste".

(5) Have you ever gotten an email that is a petition? It states a position and asks you to add your name and address and to forward it to 10 or 15 people or your entire address book. The email can be forwarded on and on and can collect thousands of names and email addresses.

A FACT:
The completed petition is actually worth a couple of bucks to a professional spammer because of the wealth of valid names and email addresses contained therein. If you want to support the petition, send it as your own personal letter to the intended recipient. Your position may carry more weight as a personal letter than a laundry list of names and email address on a petition. (Actually, if you think about it, who is supposed to send the petition in to whatever ca use it supports? And don't believe the ones that say that the email is being traced, it just ain't so!)

(6) One of the main ones I hate is the ones that say that something like, -Send this email to 10 people and you'll see something great run across your screen.-Or sometimes they just tease you by saying something really cute will happen. IT AINT GONNA HAPPEN!!!!! (Trust me, I'm still seeing some of the same ones that I waited on 10 years ago!) I don't let the bad luck ones scare me either, they get trashed. (could be why I haven't won the lottery) Before you forward an Amber Alert, or a Virus Alert, or some of the other ones floating around nowadays, check them out before you forward them. Most of them are junk mail that have been circling the net for YEARS! Just about everything you receive in an email that is in question can be checked out a Snopes. Just go to http://www.snopes.com/. It is really easy to find out if it is real or not. If it is not, please don't pass it on. So please, in the future, let's stop the junk mail and   the viruses.

Finally, here's an idea!!! Let's send this to everyone we know (but strip my address off first, please). This is something that SHOULD be   forwarded. Amen! Now I have one pet peeve. It is people who forward messages as attachments. This happens because your set up in Outlook Express is incorrect. Look in tools, options, tab send. There is a box labeled to "include message in reply. Make sure it is checked. This will stop the message becoming an attachment. Then do all the things recommended above. It only takes a little time. This message is being forwarded to you, you do not see who forwarded it to me, nor do you see any attachments. You also do not see who it is going to. This message is actually going to everyone in my email address book. Emails with attachments are suspect as soon as they hit my computer. If I do not know the name, the message is deleted good or bad.

Low Scoring Affairs, Boring Matches & Evil Pitches

2006-10-17T13:56:00.000+05:30

Will this Champions Trophy turn out to one of the boring competition ever have been played? the Answer remains predictable so far. Except for couple of qualifying games which witnessed Sri Lanka passing the 250 run mark twice, since then everything has been a low scoring affair. West Indies who were unable to put up a good show, was bowled out for 86 and almost 20 overs were remaining, and England who were been haunted again by the ghosts of India was bowled out for 120 odd. If this pattern continues, this contest will end up as a boring event.

Thumbs down to the Indian curators who couldn't produce a good quality ODI batting pitch. Pitch was one of the major factors of these low scoring affairs.

In my view, ODIs should be batting oriented. Matches should see big scores with batsmen having some big hits over the ropes and then the opposition following up may match up with the score or by scoring some where closer by making game evenly poised. A characteristic of a good cricket game is where the viewer couldn't predict who will be ultimate winner of a particular match or a series. Teams should be well developed, formed and be adaptable and good quality pitches should be provided. The present arena doesn't fulfill those criteria. For example: from the match between Australia and England till the Finals of the contest, it is easily predictable who will win the match and contest. Outcome of a match should be suspense for the viewer, where everything is valued and counted at least for our tickets which we are paying for.

The characteristics was there in the game against New Zealand and South Africa, yet it still turn out be a low scoring affair. Kiwis won the match against all odds. Hope this kind of cricket matches continue in the tournament at least with some big scores.

Knowing whether you have QuickTime ActiveX installed or not

2006-09-29T16:44:00.000+05:30

There are some Websites which has Quick-Time Oriented content, where you'll be the unfortunate one who could not view it. The problem is that your machine has not installed the Quicktime ActiveX which is required. So in order to know whether your computer has already installed or not or if your having problems viewing certain websites, pls. refer the following link which will indicate whether your machine has installed the necessary QuickTime Activex or not:

http://www.apple.com/quicktime/download/qtcheck/

Thoughts...

2006-07-05T12:20:00.000+05:30

Why is it so hard to tell the truth ...yet so easy to tell a lie,
why do we sleep in the church..but when the sermon is over we suddenly wake up?
why is it so hard to talk about God...but so easy to talk about sex?
why are we so bored to look at a Christmas magazine..but so easy to read a vibe magazine ?
why is it so easy to delete a godly offline messages ...yet we forward the nasty ones?
why are the churches getting smaller..but yet the bars and clubs are growing ??
think about it..
Just remember God is watching you in his list...

Use Transaction in MIDAS

2006-06-28T10:29:00.000+05:30

This is a article I found from Mr. Chen Jiangyong on Use of Transaction with MIDAS:

Transaction is very popular used in database programming. It's very easier used in Two-Tier application. How do it in Three-Tier? I have try to use cache-update in remote data modules and use transaction, I test it successfully in Delphi 4. But to do it cost many code and low performance. When Delphi 5 coming, I try to use the same method, but failed. Maybe this is the bug of Delphi 5. I think that many person have the same situation with me. How can use transaction in MIDAS? I try another method, just do it at BeforeUpdateRecord event. For example, when I edit table A, I want to insert a log to another table B. To do this, first:

1) create a remote data module , drop a query to select records from table A, drop a TUpdateSQL for the query, specify the SQL statement of Table A. Drop a TDatasetprovider hook to the query. Drop another query, then in its SQL property write the insert SQL statement to table B.

2) In the BeforeUpdateRecord event, I write this code:

  SetParams(UpdateSQL1, DeltaDS, UpdateKind);
  UpdateSQL1. ExecSQL(UpdateKind);
  if UpdateKind = ukUpdate then begin
    { Insert a log to Table B}
    // set the params
    Query2.ExecSQL;
  end;
  Applied := True;

3) In the client, you should also make some change. When you try to save the changes, use ApplyUpdates(0) instead of ApplyUpdates(-1). For example:

  ClientDataSet1.ApplyUpdates(0)

  This is OK. Delphi does it well. If a error occur when you try to insert a log to Table B, the transaction will rollback, then you can find that Table A's record is not changed at all.
  I have tested it at Delphi 4, It also works very well.

Good Luck.

Creating GUIDs In Delphi

2006-06-26T11:41:00.000+05:30

GUID values are unique and can be used to various tasks while programming. Therefore, it's appropriate that you know how to create one. Here Bill Todd of Team B shows to create it via Delphi:

FROM: Bill Todd $TeamB$

DATE : Thurs, Nov 25 1999 12:00 am

You can generate a GUID in code by calling CoCreateGuid as shown below. You
must add the ActiveX unit to your uses clause.

<Code>

procedure TForm1.Button2Click(Sender: TObject);
var
G: TGuid;
begin
CoCreateGuid(G);
end;

<\Code>

--
Bill

Bill Todd (TeamB)
(TeamB cannot respond to questions received via email)

Source:

Click here

Da Predator

2006-06-23T14:22:00.000+05:30

ENTER THE PREDATOR:

This is one of the coolest pics I found in the internet:

What inspired me about the "Predator" is his armoury, gadgets and his body kit. Wish I had those! The movie "Predator-1" and "Predator-2" does highlight him as the bad guy who brutually kills all bad guys. However in the movie: "AVP" his role remains more similar to the earlier movies, but later companions a human to demolish the rising alien dominancy.

Delphi Ruined him

2006-06-21T11:32:00.000+05:30

This is a gr8 quite funny and stressed post from Warren Postma I found while browsing:

Periodically I get a notion to explore the wide world of other
development tools out there. Every time I try, I get frustrated, and I
give up. Partly I think it's because my brain has locked into Delphi
mode so tightly that I can't think of anything else. Partly it's
because Delphi has spoiled me rotten, and I'm absolutely floored by the
stuff that I have to deal with when I try to use any other tool. Now
the reason I'm looking around for a new development tool to learn, is so
I can have a tool for writing cross-platform code, hopefully that will
work on Windows, Mac, and Linux.

Has anyone else been in this spot, and had a look around? What did you
do? Did you plan to have an affair with another language, and then come
home happily to Delphi, knowing it would still have you back again?

- I tried Java again recently. I was really impressed by NetBeans and
the new "matisse" GUI builder. I am not at all impressed by Eclipse,
although I like the SWT framework the gui-builders for Eclipse that are
any good are quite expensive, and I don't feel like paying $$$ just to
play around and learn the new tool.

- I tried a few Smalltalks, because as we all know, Smalltalk should
have been a really important and powerful programming languages, but for
some reason, it never achieved success. There's Dolphin, for which a
free version exists, and there's Squeak, which is entirely free. Both
are really interesting to play with, but I must admit my brain is so
wired for the procedural style of coding that I can't bear to write a
for-loop in Smalltalk, or send messages between integers. It just seems
weird and wrong to me. And closures and stuff. And I think that at
this point, learning Smalltalk is about as pointless as learning COBOL.

- I'd try a LISP, but I have no idea whether a LISP gui builder RAD tool
even exists. Perhaps LISP programmers can't be bothered to look up from
their latest EMACS macros-that-generate-macros-that-generate-LISP-code,
in order to consider the needs of the GUI-building population.

- I downloaded MS Visual C# express, but I don't like DotNet, and I'd
rather not learn another Windows-only tool. Delphi does fine for
Windows. I'd really like to learn something that gets me free from
Windows completely. Maybe DotNet is the way to go, and I should learn
to love C#, and hope that MONO achieves maturity.

- I really like Python, but every single python gui framework seems too
full of accidental complexity, or too ugly, or both. Tcl/Tk is ugly.
wxWindows is really hard to learn. QT is licensed in a way that makes
using it on Windows cost a lot of money. BOA constructor is a neat toy,
but I haven't been able to do anything useful with it yet.

- For confirmed delphi bigots, such as myself, perhaps Lazarus is the
right way to cross-platform myself, but as much progress as Lazarus has
made, it's still not ready for prime time; it lacks packages, and the
LCL/FCL components/code-libraries are rather klunky and limited in
features when compared with the VCL.

So what did YOU do last time you felt like trying another developer
tool? Can you find it in your heart to say anything good about any other
development tool? Or are you a crabby old Delphi guy like me, dyed in
the wool, and unlikely ever to repent?

Warren

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~End of Post~~~~~~~~~~~~~~~~~~~~~~~~~~`
For further reading the entire post, go to: http://delphi.newswhat.com/geoxml/forumgetthread?groupname=borland.public.delphi.non-technical&messageid=4484a839$1@newsgroups.borland.com&displaymode=all

Beginning of the end

2006-06-12T10:07:00.000+05:30

We Sri Lankan suffer the most when it comes to cost of living. Last Sunday, the Government of Sri Lanka (GOSL) increased the petrol products. This is a big blow for the consumers, particularly the average middle man who uses kerosene for cookery and other purposes. We had seen price hike of essential commodities, and in some cases with out aware of the public. Further more, the ongoing Lanka IOC and GOSL have been settled for some degree by allowing the Lanka IOC company to determine the fuel prices from July 1st. Think what might happen if Lanka IOC, a private company is given the right to determine the fuel price of Sri Lanka, the circumstances

Think of an average man's point of view. He has the burden to settle his Electricity, Water and Telephone bills, plus taxes and have to feed his family and have to look after other expenses as child's education, Travel...etc. How can a man handle with a small income. It's evident that there is hardly no saving for an individual these days, however if Cost of living soars like this, there is nothing but to suicide himself. Suicide is beginning to be a common thing, and in couple of months ago we saw two farmers suicide themselves due to can not sell their paddy for reasonable price.

The present government is playing the fiddle with the public. They acknowledged the public who voted them in the presidential election held on January by increasing the Gas price (We felt that this is not the end, but the beginning of the end), then increased essential commodities, yet again increased the fuel and more often which resulted in hike in the private bus transportation, and on last Sunday people didn't expect another fuel hike, but it happened.

As I said earlier this is the beginning and not the end of the so called "chintanaya". Tight your seat belts cos there more to come.

Being a Geek!

2006-06-01T10:45:00.000+05:30

This is a great description I got from Patti's Blog about "GEEK":

Now, don't stress just yet. I know that the term "GEEK" has been used in the past as an insult or a stereo-type for losers. However, the term "GEEK" has taken on new meaning over the past few years.

A GEEK is anyone who takes pride in what they do... and is actually good at it. GEEK is not to be confused with the term "NERD". Nerds are the people who got wedgies in high school and then would run home crying. A GEEK is someone who got a wedgie in high school, then went home and crashed the "Wedgor's" computer... or would mix a concoction in chemistry class that would give the assailant severe diarrhea for a week.

A GEEK is someone you call when your computer breaks. GEEKS are the people you contact to help you build a web site or save a database. GEEKS run the computer network at your place of work. A GEEK can be found hosting a mass LAN party. GEEKS write programs that balance your checkbook, organize your files and store/retrieve information... and restarts your computer more often so that you don't have to. A GEEK is someone you call when you have any kind of technological question. GEEKS are respected by others and are in high demand. GEEKS know what they are doing. Nerds are clueless little imps that can't tell the difference between Barney the purple dinosaur and Tux the (LINUX) penguin.

GEEK is a rockin' term, and to be a GEEK is a far greater compliment than any other. Because being a GEEK does not only mean you are good looking... but it also means that you are good at what you do.

All GEEKS should respect one another. These days, the geeks are having their revenge. Rich and successful geeks are everywhere, or at least they appear to be. There is even a Geek Pride Festival, a celebration of all things GEEK. That is why I'm rounding up all of the GEEK .. we need to stand up and shout it…

Source: http://www.geekgirldigest.com/

UNP remains the power house in Colombo

2006-05-24T09:56:00.000+05:30

Last Saturday saw the completion of Local government election and the results were out by Monday. I was really happy to see that UNP powered Independent Group 3 coming front again. Never ever in the history that the Colombo District have gone out of the hands of UNP as far as I'm concerened. People still have faith on UNP, hope it will remain unchanged.

To see the results pls follow this URL : http://www.news.lk/lg_election_2006/01A.html

Graham Thrope

2006-05-24T09:34:00.000+05:30

Memories of Graham Thrope:
England Tour of Sri Lanka 2001/02.

On last Sunday, I had the opportunity to watch Sanjay Manjerkar’s Modern Masters show, where they featured two great cricket players of England. Among them was Graham Thorpe. He was one of my favorites. The programme showed some highlights of the England Tour to the Caribbean and South Africa. This reminded me about the innings he played in Sri Lanka on the Tour in 2001. He was at his peak in this series. This series sparkled some controversy over the umpires decision made.

To give a brief summary, England was completely outplayed in the 1st Test played at Galle. The main reason behind this was the inability to cope the turning ball of Muralitharan and swing of Vaas. There feet weren’t moving well and more often you can see them stuck in the crease and was waiting for the ball to come to them. Non of the Englishmen fared well but one stood up and it was non other than the “New Kid on the Block”: Marcus Trescothick with a 119 in the First Test.

Then came the 2nd Test in Kandy. It was bright and sunny day and thankfully there weren’t any interruption from Mother Nature. The environment looked some what ideal to the Englishmen. This match saw the emergence of Graham Thorpe’s form as he scored 54 & 46. Overall, the Englishmen’s feet were moving well and they did cope the spin and swing quite well which resulted in a much wanted win and squared the series, in fact they did it with some difficulty.

Finally it was upto the 3rd Test decide the winner of the series. Sri Lanka batted first, and made 241 with Mahela Jayawardena scoring a worth wile 71. England batted in their 1st innings and were in trouble from the word “GO”. They ended up scoring 249 with Graham Thrope leading the way with an unbeaten 113 out of it and almost scoring half of team’s runs. It was great to see him in total control and handled the spin and swing very well. He cutted, reverse sweept, and the most best of all his pull which was memorable to watch. He was in control and for the first time Murali and Vaas went out of ideas. Sri Lanka’s misery continued in their 2nd innings as they went down with out a fight for a mere 81 runs. It was a disappointing effort from the Sri Lankans, Which gave the Englishmen to score a mere 74 of 25 Overs runs to wrap-up the series. England Startted yet again with trouble loosing quick wickets at regular intervals and this time it was Sanath Jayasuriya with his part time left arm spin which gave a horrible time to the englishment. It was upto Graham Thrope again and he did it with scoring an unbeten 32.

A better World in my view

2006-04-19T18:04:00.000+05:30

America rubs salt in our wounds!

Earlier they were after Iraq for WMD (which they didn’t find a single trace), now they are after Iran for the same reason. The consequences are mass amount of human deaths and higher fuel prices and many more. They are a problem, if not a nuisance for the world society. The consequences of a probable war wouldn’t affect them, but would affect the other nations in a big way, particularly the poor nations.

They said they will bring peace, but has bought the opposite. They said they will rebuild, but how can they repay the lost lives? Every effort they took was in vain. So far how many lives have lost, how many children have been orphaned? Everyday I hear that at least 10 people die in Iraq and Afghanistan. I guess America’s policy is some what like Dictatorship and Invasion of other countries. I think the era of colonialism is going to be back, we may see countries invading other countries. The same as we learned in our History books. They are teaching a very bad example for the world. This is the worst side of it.

Fuel Prices up means that Cost of living is going up. Yesterday the SL Government announced a Rs. 8 hike on fuel prices. This means public transport fares are likely to go up in due course. Further, Gas Prices, and fast food items may see a hike as well. We are getting a low income, and with that there haven’t been a single savings. Now this turn will further worsen our lives.

Sanctions: Do we see a positive result out of it?

The UN and particularly the Americans are always on the sanctions. If any countries doesn’t either obey or follow the UN order, then tighten your seat belts coz sanctions are nearby. They don’t see what’s coming out of it and who suffers the most of it? It won’t affect a political leader of that country nor its government, but those who will be suffering would be the people themselves. No medicines! No Food! Professionals migrate to other countries to seek asylum leaving hardly anyone to look up after their country.

Voting for the same government consequently: the worse side

In my point of view most of politician is not a good guy. Most of them (very few) are culprits! Always money hunger and self- concerned people rather than their own country. What’s my suggestions to all of you is don’t elect a party that have won earlier, instead vote for another party. By this, the culprits won’t get a long period to do the culprit works. Always insist on a change. At least their culprit’s works is limited.

"If I have seen further, it is by standing upon the shoulders of giants"

2006-04-08T12:03:00.000+06:00

I sense that this quote has something very special, something transparent that we could not see nor judge the outcome.

If I have seen further, it is by standing upon the shoulders of giants

Sir Isaac Newton was an English physicist, mathematician, astronomer, alchemist, inventor and natural philosopher who is generally regarded as one of the most influential scientists in history.

This quote is from a letter written to fellow scientist, Robert Hooke in February 1675. The phrase is understood to mean that if Newton had been able to discover more about the universe than others, then it was because he was working in the light of discoveries made by fellow scientists, either in his own time or earlier. There is some suggestion that the phrase may also have had a sarcastic undertone - some historians report that Robert Hooke began to disagree with a number of Newton's theories, and Hooke himself was reportedly quite short in height.

About Sir Issac Newton:
The son of a farming family, Sir Isaac Newton was born in Lincolnshire in England in 1643. He is best known as the scientist who first identified the effects of gravity. A popular story claims that Newton was inspired to formulate his theory of universal gravitation by the fall of an apple from a tree. Cartoons have gone further to suggest the apple actually hit Newton's head, and that its impact somehow made him aware of the force of gravity. However, there is no basis to that interpretation.

Unique for time, Newton is also famous for his revolutionary discoveries in mathematics, optics, physics and astronomy. His book Principia, published in 1687, is regarded as the greatest scientific book ever written, and his discoveries have been the basis for much scientific research.

To Check other good quotes, go to: BBC's Moving Words

Exporting to Text File

2006-04-04T12:28:00.000+06:00

I was in dire need to find out a function which exports table to text file. While googling around, i found out some interesting codes which I would like to share with you all.

Jeremy Collin's Code:
const
InvalidFieldTypes = [ftMemo, ftBlob, ftGraphic, ftFmtMemo,
ftParadoxOle,
ftDBaseOle, ftTypedBinary];

function TableToText(const tbl : TDataset; FileName : string;
Delimiter : Char; FieldNames : boolean): boolean;
var
f : TextFile;
i : integer;
bmk : TBookmark;
begin
if not(tbl.Active) then
tbl.Open;
bmk := tbl.GetBookMark;

AssignFile(f, Filename);
ReWrite(f);
try
with tbl do begin
if FieldNames then begin //write field names to top of file
for i := 0 to FieldDefs.Count - 1 do
if not(FieldDefs[i].DataType in InvalidFieldTypes) then begin
Write(f, UpperCase(FieldDefs[i].Name));

if i < FieldDefs.Count - 1 then
Write(f, Delimiter);
end;
WriteLn(f);
end;

//write field data
First;
while not Eof do begin
for i := 0 to FieldDefs.Count - 1 do begin
if not(FieldDefs[i].DataType in InvalidFieldTypes) then begin
Write(f, '"' + Fields[i].AsString + '"');
if i < FieldDefs.Count - 1 then
Write(f, Delimiter);
end;
end;
WriteLn(f);
Next;
end;
Result := True;
end;
finally
tbl.GotoBookmark(bmk);
tbl.FreeBookmark(bmk);
CloseFile(f);
end;
end;
--

URL

Crickets' best in 2005

2006-03-29T09:21:00.000+06:00

Sorry it took a while to publish this as I was continuously involved with a hectic schedule and hardly got a time to write freely.

2005 remarked a great era for cricket. Many milestones were achieved and many extraordinary things happened. Overall it’s been good for cricket and we are happy to see some good cricket matches. I take this opportunity to rate top 5 best things happened in 2005 in my perspective.

Rise from the Ashes:
This is simply best cricket series I ever had seen. It got all from excitement to thrill to anticipation to disappointment. England had to wait for 18 years to achieve this feat again, and boy the way they did it is awesome. Freddie Flintoff, Kevin Petersen, Simon Jones was at their peak. This is the same time when England found out their new revelation of reverse swing. You can’t take Shane Warne off the screen in any circumstances, I still remember the way he bowled Andrew Strauss by pitching the ball far from the off side and turned and hit the leg stump in that series, and boy it's amazing. Looking forward for Operation "Demolition in Australia", hope England could repeat their heroics in the next ashes in Australia.

Thrilling Tie in the Final:
Once again it’s an Australia Vs. England show. This time it’s the Shorter version of the game and the finals played for Natwest Series at Lords. The game went to the wire and it was never the end until the last ball has been bowled. Australia was bowled with a highly packed batting line out only managing for mere 196 and England were at one stage were 33 runs with 5 wickets down. It was upto Paul Collingwood and Geraint Jones who had a 116 runs partnership for the 5th wicket, though they weren’t the heros of the particular day was Ashley Giles who snicked a 2 run leg bye off the last ball of the last over.

New Kid on the Block: Michael Hussey:
Frankly, had to wait until the VB Series is on to see this guy. I heard him when Australia toured England, and was starting to make loud echoes of him. What impressed me about him was his never say die attitude. Though he might be a Michael Bevan sought of a guy, he has more than him. His ability to have the big hits on time is quite impressing and he can’t simply stay in a place always in the run. I still remember the way hit that big hit in Telstra dome, and eventually it wasn't decided as six! That was disappointing.

Bangladesh's win over Australia:
Don’t ever think that your day dreaming. This happened, and every one was shocked to hear this news. It’s like a ant pulling off an elephant. Anyway, Bangladeshi put up a good show, hats off to them, but it’s very disappointing to see good performances by more often. Ashrafull scored an unbeaten century to pull off a shocker.

Return of Brian Charles Lara:
He is my favorite and he will be. I'll be glued to the TV when he is on song. I like to see every shot he plays. He went on a poor form in 2005, particularly in the Super Series, but he came back strongly with 231 Vs. Australia in Adelaide despite Australia trouncing the West Indies to win the series 3-nil. It’s very sad that even big score scored by a batsmen still ends up in the loosing side. Further, he announced that this would be his final tour to Australia. He still is the best.

Your comments and suggestions are most welcomed.

Regards,

Hifni Shahzard Nazeer, M.