Hello guys,
My first blogpost on Hi-Tech ITO blog, reminds me one of most famous line of last millenium.
"One small step for a man, a giant leap for mankind"
Yeah, for a company which focuses on Outsourcing Solutions, for them giving employees their own personal space via blog is really rare.
Hi-Tech Outsourcing again took wonderful step for their employees, now a team of excellent technical expertise post their routine problems which are likely faced by many others.
It is also an opportunity to groom employees writing skills and interpersonal skills.
We are thankful to the management for providing us this opportunity. We really hope that this small step for employees would surely turned out giant leap for our Organization.
Here is Arpan Desai from Hi-Tech Outsourcing Solutions, by profession I am iPhone Developer, and by Choice an Apple/Mac Fan.
I will try my best to en-light & highlight recent developments in Apple , iPhone/iPad , Mac OS, Twitter and Tech News at whole.
Todays' Insights are related to Sqlite:
You can use this function to get the number of records from any table.
All you need to is pass the query , as a parameter.
+(int)CountQuery:(NSString*)query;{
//NSMutableArray *recordAry = nil;
int totalCount;
if([SqliteLib OpenDB])
{
sqlite3_stmt *selectStmt = nil;
if (sqlite3_prepare_v2( database, [query UTF8String], -1, &selectStmt, nil) == SQLITE_OK)
{
//recordAry = [[[NSMutableArray alloc]init] autorelease];
while (sqlite3_step(selectStmt) == SQLITE_ROW)
{
totalCount = sqlite3_column_int(selectStmt, 0);
}
}
}
[SqliteLib closeDB];
return totalCount;
}
No comments:
Post a Comment