NSString *sql1 = [[NSString alloc] initWithFormat:@"Select * FROM Table1 where name='%@'", paramName];
NSString *sql = [NSString stringWithUTF8String:[sql1 UTF8String]];
sqlite3_stmt *selectstmt = nil;
if(sqlite3_prepare_v2(database, [sql UTF8String], -1, &selectstmt, NULL) == SQLITE_OK)
{
while(sqlite3_step(selectstmt) == SQLITE_ROW) { ....... }
}
#import "Calculation.h"
@implementation Calculation
- (int) add5: (int) num
{
int result;
result = num 5;
return result;
}
@end
#import <Foundation/Foundation.h>
@interface Calculation : NSObject {
}
- (int) add5: (int) num;
@end
/Volumes/Windows/Development/GoogleToolsForMac/UnitTesting/RuniPhoneUnitTest.sh
if (sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK) {
const char *sql = "select tbl_name from sqlite_master";
sqlite3_stmt *selectstmt;
NSLog(@"SQLite= %d", sqlite3_prepare_v2(database, sql, -1, &selectstmt, NULL));
#import <Foundation/Foundation.h>
#import <UIKit/UIKit.h>
#import <sqlite3.h>
@interface Category : NSObject {
NSInteger categoryID;
NSString *categoryDescription;
//Intrnal variables to keep track of the state of the object.
BOOL isDirty;
BOOL isDetailViewHydrated;
}
@property (nonatomic, readonly) NSInteger categoryID;
@property (nonatomic, copy) NSString *categoryDescription;
@property (nonatomic, readwrite) BOOL isDirty;
@property (nonatomic, readwrite) BOOL isDetailViewHydrated;
@end
#import "Category.h"
@implementation Category
@synthesize categoryID, categoryDescription, isDirty, isDetailViewHydrated;
- (void) dealloc {
[categoryDescription release];
[super dealloc];
}
@end
#import <Foundation/Foundation.h>
#import <UIKit/UIKit.h>
#import <sqlite3.h>
@interface Joke : NSObject {
NSInteger jokeID;
NSInteger jokeCategory;
NSString *jokeText;
NSString *jokeSource;
NSString *jokeGraphic;
//Intrnal variables to keep track of the state of the object.
BOOL isDirty;
BOOL isDetailViewHydrated;
}
@property (nonatomic, readonly) NSInteger jokeID;
@property (nonatomic, readonly) NSInteger jokeCategory;
@property (nonatomic, copy) NSString *jokeText;
@property (nonatomic, copy) NSString *jokeSource;
@property (nonatomic, copy) NSString *jokeGraphic;
@property (nonatomic, readwrite) BOOL isDirty;
@property (nonatomic, readwrite) BOOL isDetailViewHydrated;
@end
#import "Joke.h"
@implementation Joke
@synthesize jokeID, jokeCategory, jokeText, jokeSource, jokeGraphic, isDirty, isDetailViewHydrated;
- (void) dealloc {
[jokeText release];
[jokeSource release];
[jokeGraphic release];
[super dealloc];
}
@end
#import <Foundation/Foundation.h>
#import <UIKit/UIKit.h>
@class Category;
@class Joke;
@interface SQLAppDelegate : NSObject <UIApplicationDelegate> {
UIWindow *window;
UINavigationController *navigationController;
//To hold a list of Category objects
NSMutableArray *categoryArray;
NSMutableArray *jokeArray;
}
@property (nonatomic, retain) IBOutlet UIWindow *window;
@property (nonatomic, retain) IBOutlet UINavigationController *navigationController;
@property (nonatomic, retain) NSMutableArray *categoryArray;
@property (nonatomic, retain) NSMutableArray *jokeArray;
- (void) copyDatabaseIfNeeded;
- (NSString *) getDBPath;
@end
- (void)switchToNewView:(id)sender
{
// get the view that's currently showing
UIView *currentView = self.view;
// get the the underlying UIWindow, or the view containing the current view view
UIView *theWindow = [currentView superview];
// remove the current view and replace with myView1
[currentView removeFromSuperview];
[theWindow addSubview:self.dataviewView]; // <<<--- Crash on this line
}
This was due to the fact I'd failed to download the new SDK, even though my iTouch had automatically been upgraded via iTunes. The original bundle had been developed for iPhone OS 2.0 while the debug device was running under OS 2.2. Downloading the new version of the SDK from Apple addressed the issue.
The problem I have with this is that the new SDK is over 1Gb in size! Its hard to believe I'll have to download that much each time there is a new update to the Framework.
USE master
GO
IF EXISTS (select name from sysdatabases where name='JokeGenDB')
BEGIN
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'JokeGenDB'
DROP DATABASE [JokeGenDB]
END
GO
CREATE DATABASE [JokeGenDB] ON PRIMARY
( NAME = N'JokeGenDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\JokeGenDB.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'JokeGenDB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\JokeGenDB_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
GO
ALTER DATABASE [JokeGenDB] SET COMPATIBILITY_LEVEL = 100
GO
ALTER DATABASE [JokeGenDB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [JokeGenDB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [JokeGenDB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [JokeGenDB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [JokeGenDB] SET ARITHABORT OFF
GO
ALTER DATABASE [JokeGenDB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [JokeGenDB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [JokeGenDB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [JokeGenDB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [JokeGenDB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [JokeGenDB] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [JokeGenDB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [JokeGenDB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [JokeGenDB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [JokeGenDB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [JokeGenDB] SET DISABLE_BROKER
GO
ALTER DATABASE [JokeGenDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [JokeGenDB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [JokeGenDB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [JokeGenDB] SET READ_WRITE
GO
ALTER DATABASE [JokeGenDB] SET RECOVERY FULL
GO
ALTER DATABASE [JokeGenDB] SET MULTI_USER
GO
ALTER DATABASE [JokeGenDB] SET PAGE_VERIFY CHECKSUM
GO
USE [JokeGenDB]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [JokeGenDB] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
USE [JokeGenDB]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[JokeCategory]') AND type in (N'U'))
DROP TABLE [dbo].[JokeCategory]
GO
CREATE TABLE [dbo].[JokeCategory](
[Category] [int] IDENTITY(1,1) NOT NULL,
[Description] [varchar](50) NOT NULL,
CONSTRAINT [PK_JokeCategory] PRIMARY KEY CLUSTERED
(
[Category] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [JokeGenDB]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Joke_JokeCategory]') AND parent_object_id = OBJECT_ID(N'[dbo].[Joke]'))
ALTER TABLE [dbo].[Joke] DROP CONSTRAINT [FK_Joke_JokeCategory]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Joke]') AND type in (N'U'))
DROP TABLE [dbo].[Joke]
GO
CREATE TABLE [dbo].[Joke](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Category] [int] NOT NULL,
[Text] [varchar](2000) NOT NULL,
[Source] [varchar](200) NULL,
[Graphic] [varchar](200) NULL,
CONSTRAINT [PK_Joke] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [JokeGenDB]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Joke_JokeCategory]') AND parent_object_id = OBJECT_ID(N'[dbo].[Joke]'))
ALTER TABLE [dbo].[Joke] DROP CONSTRAINT [FK_Joke_JokeCategory]
GO
ALTER TABLE [dbo].[Joke] WITH CHECK ADD CONSTRAINT [FK_Joke_JokeCategory] FOREIGN KEY([Category])
REFERENCES [dbo].[JokeCategory] ([Category])
GO
ALTER TABLE [dbo].[Joke] CHECK CONSTRAINT [FK_Joke_JokeCategory]
GO
USE JokeGenDB
DELETE FROM [JokeGenDB].[dbo].[JokeCategory]
GO
SET IDENTITY_INSERT [JokeGenDB].[dbo].[JokeCategory] ON
GO
INSERT INTO [JokeGenDB].[dbo].[JokeCategory]
([Category], [Description])
VALUES
(1, 'Knock, Knock')
GO
INSERT INTO [JokeGenDB].[dbo].[JokeCategory]
([Category], [Description])
VALUES
(2, 'Doctor, Doctor')
GO
INSERT INTO [JokeGenDB].[dbo].[JokeCategory]
([Category], [Description])
VALUES
(3, 'Irish')
GO
INSERT INTO [JokeGenDB].[dbo].[JokeCategory]
([Category], [Description])
VALUES
(4, 'General')
GO
SET IDENTITY_INSERT [JokeGenDB].[dbo].[JokeCategory] OFF
GO
USE JokeGenDB
GO
DELETE FROM [JokeGenDB].[dbo].[Joke]
GO
SET IDENTITY_INSERT [JokeGenDB].[dbo].[Joke] ON
GO
INSERT INTO [JokeGenDB].[dbo].[Joke]
( [ID], [Category], [Text], [Source], [Graphic])
VALUES
(1, 1,
'"Knock, Knock". "Who''s there?", "Sarah", "Sarah Who?", "Sarah doctor in the house."'
,null,null )
GO
INSERT INTO [JokeGenDB].[dbo].[Joke]
( [ID], [Category], [Text], [Source], [Graphic])
VALUES
(2, 1,
'"Knock, Knock". "Who''s there?", "Orange", "Orange Who?", "Orange you glad to came-a-knocking?"'
,'http://www.knock-knock-joke.com',null )
GO
INSERT INTO [JokeGenDB].[dbo].[Joke]
( [ID], [Category], [Text], [Source], [Graphic])
VALUES
(3, 2,
'"Doctor, doctor I swallowed a bone.". "Are you choking?", "No, I really did!"'
,'http://www.ahajokes.com',null )
GO
INSERT INTO [JokeGenDB].[dbo].[Joke]
( [ID], [Category], [Text], [Source], [Graphic])
VALUES
(4, 3,
'"An Irish man is eating in a restaurant, when the waiter throws a prawn cocktail over him. "What''s that for?" he says shocked. The waiter replies "Thats just for starters!".'
,'http://irishjokes.com',null )
GO
INSERT INTO [JokeGenDB].[dbo].[Joke]
( [ID], [Category], [Text], [Source], [Graphic])
VALUES
(5, 4,
'Two zebras are talking and one asks the other, "Am I black with white stripes or white with black stripes?" The other replies, "Well I don''t know. You should pray to God about that and ask him." So that night he did and God replied, "You are what you are." The next day he said to the other zebra, "I still don''t understand what I am because God just said, You are what you are." The second zebra responds, "You must be white with black stripes or else God would have said, Yo is what yo is." '
,'http://www.coolfunnyjokes.com',null )
GO
SET IDENTITY_INSERT [JokeGenDB].[dbo].[Joke] OFF
GO
USE [JokeGenDB]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Joke_JokeCategory]') AND parent_object_id = OBJECT_ID(N'[dbo].[Joke]'))
ALTER TABLE [dbo].[Joke] DROP CONSTRAINT [FK_Joke_JokeCategory]
GO
ALTER TABLE [dbo].[Joke] WITH CHECK ADD CONSTRAINT [FK_Joke_JokeCategory] FOREIGN KEY([ID])
REFERENCES [dbo].[JokeCategory] ([Category])
GO
ALTER TABLE [dbo].[Joke] CHECK CONSTRAINT [FK_Joke_JokeCategory]
GO
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Runtime.Serialization;
/// <summary>
/// Summary description for WSGetAllResponse
/// </summary>
[DataContract(Namespace = "http://tempri.org/")]
public class WSGetAllResponse
{
private List<JokeGenDBModel.Joke> _jokes = new List<JokeGenDBModel.Joke>();
[DataMember]
public List<JokeGenDBModel.Joke> Jokes { get {return _jokes;}
set {_jokes = value;}}
}
[OperationContract]
WSGetAllResponse GetJokes(WSGetAllRequest wsJokeRequest);
[OperationContract]
WSGetAllCategoriesResponse GetJokeCategories();
public WSGetAllResponse GetJokes(WSGetAllRequest wsJokeRequest)
{
WSGetAllResponse wsGetAllResponse = new WSGetAllResponse();
using(JokeGenDBModel.JokeGenDBEntities jokeGenDBEntities = new JokeGenDBEntities())
{
ObjectQuery<JokeGenDBModel.Joke> jokeQuery = jokeGenDBEntities.Joke;
wsGetAllResponse.Jokes = jokeQuery.ToList();
}
return wsGetAllResponse;
}
public WSGetAllCategoriesResponse GetJokeCategories()
{
WSGetAllCategoriesResponse wsGetAllCategoriesResponse = new WSGetAllCategoriesResponse();
using (JokeGenDBModel.JokeGenDBEntities jokeGenDBEntities = new JokeGenDBEntities())
{
ObjectQueryjokeQuery = jokeGenDBEntities.JokeCategory;
wsGetAllCategoriesResponse.JokeCategories = jokeQuery.ToList();
}
return wsGetAllCategoriesResponse;
}
private void btnGetAll_Click(object sender, EventArgs e)
{
using (JokeClient wcfJokeGen = new JokeClient())
{
WSGetAllRequest wsGetAllRequest = new WSGetAllRequest();
wsGetAllRequest.RefreshDate = DateTime.Now;
WSGetAllResponse wsGetAllResponse = wcfJokeGen.GetJokes(wsGetAllRequest);
MessageBox.Show(String.Format("Records returned = {0}", wsGetAllResponse.Jokes.Length), "Record Count", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
