SQLite Query

On the terminal of Mac 10.6
(Application -> Utility -> Termincal )

sqlite3 abc.sql

CREATE TABLE IF NOT EXISTS InfoAll (sno INTEGER PRIMARY KEY AUTOINCREMENT,username TEXT, pswd TEXT, link TEXT, hint TEXT);

CREATE TABLE IF NOT EXISTS mainTable(mastersno INTEGER PRIMARY KEY AUTOINCREMENT,masterusername TEXT, masterpswd TEXT);

.quit

select 'DROP table ' || name from sqlite_master where type = 'table';
-----  =====>
DROP table sqlite_sequence
DROP table mainTable
DROP table InfoAll

Some well used codes

======= framework path as iAD game path
/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS4.2.sdk/System/Library/Frameworks/iAd.framework

Maybe you can reference it only by adding in the Build Setting -> Other Linker Flags the value -weak_framework and after that entrance add in another row iAD

=======alert view
UIAlertView    *alert = [[UIAlertView alloc] initWithTitle:@"Password Changed"
                                                        message:@"Successfully"
                                                       delegate:self
                                              cancelButtonTitle:@"Ok"
                                              otherButtonTitles:nil];
        [alert show];
        [alert release];
      
================ NAVIGATION CODE
SignInHomePage *detailViewController = [[SignInHomePage alloc] initWithNibName:@"SignInHomePage" bundle:nil];
detailViewController.name = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement,3)];
detailViewController.masterID = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement,0)];
[self.navigationController pushViewController:detailViewController animated:YES];
[detailViewController release];
  
================DB CODE
        sqlite3 *database;
  

iAD intergration codes

http://bees4honey.com/blog/tutorial/how-to-add-iad-banner-in-iphoneipad-app/
http://www.raywenderlich.com/1371/how-to-integrate-iad-into-your-iphone-app
http://developer.apple.com/support/ios/iad-network.html

Code by GauravDS ----------

Step 1 :  Make a view based application and suppose I get name as "iADTest".
Step 2 :  Import iAD.framework from add exiting framework. If u didn't get it on list, click on add other and add it from the path
Macintosh HD/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS4.2.sdk/System/Library/Frameworks/iAd.framework
optional if above will not find-
Maybe you can reference it only by adding in the Build Setting -> Other Linker Flags the value -weak_framework and after that entrance add in another row iAD

Step 3 : write below code in files, or if u made a new file which contain .h, .m & .xib file then in that file u have to write this code. Suppose u made a new view based file ABC (.h, .m & .xib) then make a code in


in iADTestViewController.h file (full code is here )
===================
#import <UIKit/UIKit.h>
#import <iAd/ADBannerView.h>

Text Field Hides keyboard iPhone New Updated code

#pragma mark keyboard Hides code
/*
===  This code handles the scrolling when tabbing through input fields ===
 -> Should remeber that taxtField should "delegate" to "Files Owner"
             or should select "textField.delegate=self;"

 ---prototype   .h file
//add IBOutlet UITextField *textField1,*textField2;
 -(void)releaseKeyboard;
 -(IBAction)dismissKeyboard:(id)sender;        // this method is used on the UITextField event "Did End On Exit"