Communication is Everything! Part 1: Keep Talking

... And everything is communication.

This blog has been in the blogger drafts section for eternity.  I decided to bring it out today and publish it.

I will keep it short and simple.
 Keep Talking: If you love somebody, if you value somebody, then talk to them. In many cases you will find that they were always ready to listen it was you who were switching them off. These are the common excuses that I find for not communicating:
a. I am tired: If this communication is with your spouse, kids, parents and you are too tired to talk to them then  first of all evaluate why you are tired. Is it because you are working too hard? Then ask why are you working too hard. There is a very very very good chance that you are too disorganized. Get a grip of your life and modify your lifestyle.
b. I am busy: Many people are there but they are not there. I am sometimes home but am thinking about some work in the office. Sometimes my wife is calling me but I am too engrossed in reading the newspaper, magazine or a book. When you want to communicate, you have to tell yourself that very thing a thousand times over in your head " I want to communicate!!!". This will help you realize that your loved one has opened a channel for communication and you should pick it up. It is not necessary that every communication should last a eternity or you should chat throughout the night and loose track of the time. The essential thing is that you should be able to understand what your loved one is thinking, what is going on in their mind, what are their current priorities. If  you are able to gauge them future communications will be easier to start.
c. I am in difficult situation elsewhere: I don't have time for this: Remember if you are in a difficult situation, your loved ones are the biggest asset. When everything is going against you they may be the only people there to support you. So do not be a wastrel and dump this asset. In the difficult times this communication may also lend you some mental comfort which may help you get out of the mess you are in faster.

Remember when you say that something else is more important for me and I can talk to you later, is received as "You are not important for me and I will talk to you when I get time." Would you like that kind of insult yourself?


Do visit my company website at www.indiaadityanetworks.com, if you have anything related to electronics or engineering.

The problem of Unique Records

Hi All!

with 40 visits in nearly one year, and to add insult to injury, most of them have been by me, there is very little one can say about 'All'.

We ran into a very different problem recently. We have an application on a vehicle from which we are extracting the data using a hand-held device. The hand-held device communicates with the truck mounted device using RS-485 communication protocol.

The hand-held device is then brought to the computer where it transfers the data to the computer using USB port. 

The hand-held device has some issues. In the sense that there is a chance that it can send the same data to the computer multiple times. 

The computer software is a VC++ application connecting to Access database using ODBC. We decided to remove the multiple records from the database by running the following queries on the database:

Step 1:

All the records reside in the table Consumption.

We created a table to hold some data temporarily by name of CMPNTMP2. 

We deleted all the records in the table using the query command:

DELETE * FROM CMPNTMP2

Step 2:

Next we selected all the distinct records from the main consumption database and copied them to the temporary CMPNTMP2 table using following query:

INSERT INTO CMPNTMP2 SELECT DISTINCT * FROM CONSUMPTION

Step 3:

Then we deleted all the records in the consumption table:

DELETE * FROM CONSUMPTION 

Step 4:

And finally we copied all the records in the CMPNTMP2 table to CONSUMPTION Table:

INSERT INTO CONSUMPTION SELECT * FROM CMPNTMP2

And Wallah! we had all the unique records!!!

Do visit our site: www.indiaadityanetworks.com to see what we do!

Do drop in a message or two, that will keep us going