Toad: What to do when Toad gives error for any query you execute

I use Toad for Data Analysts at work. At times, for any query you execute, this is the standard answer from toad:

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.Editor.EditorForm.PostChanges()
at Quest.Toad.Editor.EditorForm.DoExecuteSqlStatement()
at Quest.Toad.Editor.EditorForm.ExecuteSqlStatement()

In layman terms, what this means is it does not have a place to output your sql execution. Do the below:

Right click on the window area.

Select “Show Script Results”

Re-execute and see the results.

Have a good day and keep rocking!!

Advertisements

Reading so far

This year, I wanted to read more books than 2012. Here goes my list of completed books:

1. The Road less travelled – M.Scott Peck

2. 59 Seconds :Think a little, change a lot – Richard Wiseman

3. Change Your Brain, Change Your Life – Daniel G Amen

4. Don’t lose your mind, Lose your weight – Rujuta Diwekar

5. Women and the Weight loss tamasha – Rujuta Diwekar

6. The Art of Choosing – Sheena Iyengar  (Finished : 22 Mar 2013)

7. Inbound Marketing: Get Found Using Google, Social Media, and Blogs (New Rules Social Media Series) – Brian Halligan and Dharmesh Shah ( Finished: 2 April 2013)

8. Brain Rules for Baby – John Medina ( Finished : 17April 2013)

9. Thousand Splendid Suns – Khaled Hosseini ( Finished: 24 April 2013)

10. 2 States – Chetan Bhagat ( Finished: 25 April 2013)

11. Lean In – Sheryl Sandberg ( Finished: 3 May 2013)

12. Entreprenueur 5 PM to 9 AM – Kanth Miriyala & Reethika Sunder ( Finished: August 1st, 2013)

13. The Shiva Trilogy – Amish Tripathi (Finished: August 31st, 2013)

All of these books are once in life time and I am really really glad I read them all. Will post a detailed review of the books soon.

Have a good day and keep rocking!!

Disappearing Icons in Toad for Data Analysts

This is very very strange. While working from home, one day – each icon i clicked started disappearing. Very strange. After much analysis, i found out the solution. Due to lack of time, just posting the steips :

1. Right click. Just make sure the option is selected.

2. Click on the dropdown, and select the options that lead to resetting the toolbar.

3. Confirm and then see if all the icons appear.

Have a great day and keep rocking!!

How to get your 2 year old to eat

Image

This is the standard answer for anything I want to feed my 2 and half year old daughter. I dread starting her food times. I ponder over other kids who eat food – atleast the same kind everyday and finish their mealtimes in 1 hour’s time. Despite my best efforts, my daughter remains to carry the sign “NO FOOD NO DRINK PLEASE” wherever food is place in front of her. Now, from 7 months of staying at home and feeding her all the meals – I really sometimes cry out loud thinking when she will grow up and i can finish her meals like any other activity in my life. But, every passing day she just grows naughty and her meal portions get lesser and lesser. What to do?

Over time, I’ve mastered few techniques to deal with extreme poor eaters like my daughter. As always, there is a first for everything. Think over these questions and write down the answers:

1. How is your family history? Are they good, fussy or non-eaters?

Most likely, your kid will inherit the family food eating patterns. If you have fussy and picky eaters in your family ( in-laws side) , then understand that mostly it’s in her genes to reject food.

2. What is her pattern with things in life?  What are the activities that interest them most?

Some kids like to play in the park, some kids like to sit in water and some like to watch TV. Mix these activities with food. Get them so involved that they do also eat viewing as a combined activity.

3. Threats work. Really, they do.

Once you find out what they like, include small threats to make sure they eat while they get to do what is interesting to them.

4. Create hype surrounding food.

It doesn’t pay to talk a lot about food, but creating hype about a new food you want to introduce will work most of the times. Even if it doesn’t work then – don’t worry. Your little one is storing all the information in their little ROM and will one day surprise you by repeating the hype to you.

5. Don’t pressure them into eating food. DON’T SHOUT.

Eating is a good thing to do. It’s not a chore that must be completed – come 1 PM in the afternoon and 8 PM in the night. Try all your tips but in the end – if they don’t want to – let them be. Under any circumstances – never ever shout on the food for not eating food and make them feel like losers. In the end – once your kid is grown up they will eat. It’s just a matter of when – some eat at 2, some at 5 and some at 10. May be, your kid is a late bloomer with food, just get on with it.

6. Finish your mealtimes before them.

This is a very important tip. You can deal with non-eaters only if you are full of energy. I learnt this very hard way, now all my mealtimes are done before her. That way, i have enough energy to deal with her tantrums.

These are the tips on the top of my mind at the moment. What are your tips?

Have a great day and keep rocking!!

Help : Movie Review

Image

 

While browsing the channels, I came across this thriller produced in 2010, starring bobby deol, mughda godse and obviously a ghost. The movie has received its fair share of brickbats on the cyberspace, but i loved the movie.

An unborn foetus who will be aborted in favor of her mother being alive – takes revenge by causing every one of the family members to death.  Shreyas Talpade and Bobby deol acted well in the movie. The climax was a bit hard to believe but overall – it’s much better than the horror movies being done these days.

If its on the TV and you have some great snacks to munch along and no small kids in the vicinity, go for it !

Rating:  3/5

Recipe 9 : Papad ki Sabzi

Image

I’ve bookmarked the recipe long time ago, but yesterday the recipe happened as I was not in mood to cut a single vegetable. I still had to cut onions though. 🙂 Here goes the recipe:

Total time : 35 mins

Recipe for : 5 people

Papad – 10 medium size, roasted or fried in oil

Onions – 2 medium size, finely chopped

Garlic – 4 pods, minced well

cumin – 1 tbsp

Asafoetida – 1/8 tbsp

Curry leaves, coriander leaves, pudina leaves – few twigs each, as per availability

For the yogurt base

Yogurt – 250 gm

Coriander powder – 2 tsp

Red chilli powder – 1 tsp ( Adjust to taste)

Salt – to taste

Turmeric – 1/2 tbsp

Amchur Powder – 1/2 tsp

Method:

1. Take sufficient oil in pan, roast the papad and set aside.

2. Drain off the extra oil. Keep 2 tsp oil in pan, add cumin, asafoietida, onion, garlic and let it cook well.

3. While onion is cooking, prepare yogurt gravy by mixing all the ingredients mentioned above. You can do a taste test to see if the taste is ok at this point, adjusting the salt.

4. Put the stove on really low flame and add the yogurt gravy to the cooked onions. Let it cook on low flame until the oil separates from the sides.

5. Cut papad into small pieces with hand. Add the papad into cooked yogurt gravy. Cover it and cook well. Add the curry leaves, coriander leaves and pudina at this point and mix well.

Serve it with chapati.

Verdict:

Awesome!!!  Everyone loved it. I was a bit apprehensive of the taste, but the papad blended really well.  And it tasted great.

Points :

1. As per the original recipe, we can add the papad raw. I roasted them as per my family’s tastebuds. You can make your choice.

Here is the original recipe I followed:

http://showmethecurry.com/curries/papad-ki-subzi-rajasthani-cuisine.html

Have a great day and keep rocking!!