IT priorities 2008/09

Source: ZDNet Asia IT Priorities Survey 2008/09

prism error on chrome...

chrome not ready for sap? or prism not ready for chrome?

Philippine Telcos' Wireless Mobile Broadband Comparison/Matrix

	Smartbro	Globe Visibility	Sun Broadband
Connection/	GPRS/EDGE/	GPRS/EDGE/3G/	GPRS/EDGE/
Technology	3G/HSDPA	HSDPA/Wiz Wi-Fi	3G/HSDPA
Plan A
Monthly Cost (Php)	799	799	799
Mobile hours	60 hrs	40 hrs	60 hrs
Max speed (bps)	2mb	3G 384k, hsdpa 1.8m	400k
Excess	P10 /30 mins	P5 /15 mins	P0.30 / min
Free	x	2 Wi-Fi hrs	x
Plan B
Monthly Cost (Php)	999	999	999
Mobile hours	not mobile	60 hrs	Unlimited
Max speed (bps)	384k	3G 384k, hsdpa 1.8m	400k
Free	unlimited hrs, canopy install	3 Wi-Fi hrs	x
Plan C
Monthly Cost (Php)	1500	1499	1999
Mobile hours	Unlimited	100 hrs	Unlimited
Max speed (bps)	2m	3G 384k, hsdpa 1.8m	1.4m
Excess	x	P5 /15 mins	x
Free	x	Unlimited Wi-Fi	x
Prepaid
Usage Cost (Php)	P10 /30 mins	P5 /15 mins	x
Modem Kit	P2,500	P2,500	x
Max speed (bps)	2m	3G 384k, hsdpa 1.8m	x
Free	5 hrs	1.5 hrs	x

Delphi 2009 ??? !!!

Just when I thought Delphi was already obsolete and died, here comes Delphi 2009 with a lot of excellent reviews.

Borland Delphi may have died, CodeGear Delphi 2009 looks like a hit with a by line "The fastest way to build NATIVE Windows applications".

I'll watch retro Santa's videos first then download the trial. Let's see...

Solved Problem: SQL Error on Triggers with sub-triggers or sub-queries...

Trigger SQL Statement:
CREATE TRIGGER [dbo].[tr_batch_delete] ON [dbo].[tr_batch]
FOR DELETE
AS
BEGIN
DELETE FROM tr_month WHERE tr_year = (SELECT tr_year FROM Deleted) AND tr_month = (SELECT tr_month FROM Deleted) AND code_country = (SELECT code_country FROM Deleted)
DELETE FROM tr_factor WHERE tr_year = (SELECT tr_year FROM Deleted) AND tr_month = (SELECT tr_month FROM Deleted) AND code_country = (SELECT code_country FROM Deleted)
DELETE FROM tr_adjust WHERE tr_year = (SELECT tr_year FROM Deleted) AND tr_month = (SELECT tr_month FROM Deleted) AND code_country = (SELECT code_country FROM Deleted)
END;

Error:
Server: Msg 512, Level 16, State 1, Procedure tr_batch_delete, Line 5
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

Solution:
Replace = with IN

Solved Problem: ODBC Error: "Connection is busy with results for another hstmt"

This error has bugged me for a while using Microsoft SQL with Delphi through an ODBC connection. OBDC can only have one active cursor at a time. By default, odbc only retrieves the first 20 records for a query. This error occurs if a query contains more than 20 records which are usually retrieved on demand. This is fine until a second query is executed using same connection/session, the error then pops-out.

I searched and bumped with MARS (Multiple Active Record Sets) articles and solutions but I found an easier one.

Solution:
Set the odbc rowset size to a larger number. If you set it to 200, then the first 200 records will be returned. If you set it to -1 then ALL records will be returned. This is not a good practice and performance will suffer if a query result set is large.

To set the rowset size with the BDE, do the following:

1. Click on your TDatabase component
2. In the object inspector, expand Params
3. Put in a Key of "ROWSET SIZE"
4. Put in the desired value

Changing the rowset size should work with other odbc connection components as well.

Thanks to Sean's post.

What is Cloud Computing?