RowID and ORA-00937: not a single-group group function

I have been facing this error for quite sometime now. No its not that I have not properly used group by function. My SQL reads something like this in error log file

Select nvl(max(id_no),0) id_no, Desig.ROWID from ......

But my actual SQL query in VB does not have a Desig.ROWID . Then from where did this ROWID got inserted ?
This is what actually happens :

When I looked into my VB code, I found while making a recordset, that the locktype used was adOptimistic. This mode is used when we need to read the data from database, modify it then again save it back to database. So he needs to know which row has to be updated which results in adding a rowid to query. So the solution to this problem is to use readonly mode.




Tags : RowID, Oracle, ORA-00937, single-group

MR Wagon - The "New Zen" From Maruti

The Maruti Suzuki is all set to launch the all new Zen here in India. The "New Zen" is expected to replace the ever reliable Zen. The price tag will be anywhere between Rs 3-4 Lakhs. The production of the Zen is being stopped.This is the obvious reason for heavy discounts on Zen. So it upto you to decide if these discounts are really worth for it. Wait for couple of months and you will find a all new car in the same range named "New Zen" ( probably ).

The "New Zen" is not a new model from Suzuki. It was launched way back in 1999 in Japan. It was named MR Wagon. Its the same MR Wagon being launched here in India under a new name. Interestingly the MR Wagon has been phased out in Japan. Do we deserve phased out cars in India ? Similiar work was done with the Swift. Swift had an old Esteem engine in it. With the growing car market in India, we need newer and better engines. Meanwhile the MR Wagon is not at all as trendy as newly launched Swift. There is nothing new in the MR Wagon. Here are the specification of MR Wagon.


MR WAGON SPECIFICATIONS
price: Rs 3-4 lakh
power: 64 bhp@6400 rpm
torque: 8.56 kgm@3500 rpm
length: 3401 mm
width: 1575 mm
height: 1669 mm
wheelbase: 2334 mm
fuel tank: 30 litres
engine: 1061 cc, 4 cyliners inline
installation: front, reverse, FWD
specific output: 60.32 bhp/litre
bore/stroke: 68.5/72 mm
gearbox type: 5 speed manual
front suspension: McPherson strut
rear suspension: three link rigid type
front brakes: ventillated discs
rear brakes: drums
tyre: 145/70 R13

These specifications are quite similiar to Wagon R. What new in the MR Wagon .. may be a bit tweaked Wagon R as far as looks are concerned. Lets wait and watch how Indian consumers react to all new old model from Suzuki..

Tags : Maruti, MR Wagon, New Zen

Microsoft XP Desktop Search Bug

Well I just found a bug in the windows XP. I am not aware if its a known bug or it has been rectified by Microsoft. Just go to the Windows XP desktop and press CTRL + F. The search box appears.











Now enter some search text and press enter. What you get is Error: 122 'location' is null or not an object. Ah work for some microsoft to improve user experience.



Tags : microsoft, XP, search, Bug, Desktop