您现在的位置:首页 >> 其它平台 >> IOS >> 内容

ios教学:在ios使用InterBase ToGo

时间:2013/5/6 2:56:15 点击:

  核心提示:iOS Tutorial: Using InterBase ToGo in an iOS ApplicationGo Up toiOS Tutorials: Delphi iOS Applicatio...

    iOS Tutorial: Using InterBase ToGo in an iOS Application

 

Go Up to iOS Tutorials: Delphi iOS Application Development

Contents

 

Before starting this tutorial, you should read and perform the following tutorial session:

Tip:  Following this tutorial requires a  license  for  IBToGo  or  IBLite . If you have purchased RAD Studio XE4 Professional and up, or Delphi XE4 Professional with Mobile and up, you have received a key for an unlimited development and deployment license for IBLite. If you are a trial user, and would like to test InterBase on iOS, you can get access to an IBToGo test deployment license during your trial. To activate your deployment trial license, please follow this link: InterBase ToGo Deployment .

This tutorial describes the basic steps to browse data managed by InterBase ToGo on your iOS device through the dbExpress framework.

    Using dbExpress to Connect to the Database

dbExpress is a very fast database access framework, written in Delphi. RAD Studio provides drivers for most major databases, such as InterBase, Oracle, DB2, SQL Server, MySQL, Firebird, SQLite and ODBC. You can access these different databases using procedures similar to the procedure described here.

  • For the iOS platform, dbExpress supports InterBase ToGo as well as SQLite. These database products can run on iOS devices.
  • For other databases, such as Oracle, you need to have at least a client library. On Windows platforms, the client library is provided as a DLL to connect to. Therefore, you need to develop applications using middle-tier technologies such as DataSnap to connect to these database products from iOS devices.

Another tutorial discusses how to connect to Enterprise Database without using a client library on iOS device; see iOS Tutorial: Connecting to an Enterprise Database from an iOS Client Application.

    Design and Set Up the User Interface

This tutorial uses one TListBox component as the UI element.

To set up a ListBox component, use the following steps:

  1. To create an HD FireMonkey Mobile Application, select File > New > FireMonkey Mobile Application - Delphi > Blank Application.
  2. Drop a TListBox component on the form.
  3. In the Object Inspector, set the following properties of the ListBox:
    • Set the Align property to alClient, so that the ListBox component uses the entire form.
    • Set the DefaultItemStyles.ItemStyle property to listboxitembottomdetail.
  4. Right-click the TListBox component in either the Designer or the Editor, select Add Item, and add the following components:
  5. Close the Items Designer.
  6. Add a TLabel component to the TListBoxHeader, and set the following properties in the Object Inspector:
    • Set the Align property for the TLabel component to alClient.
    • Set the StyleLookup property to toollabel.
    • Set the TextAlign property to taCenter.
    • Set the Text property to DB DEMO.

    Connecting to the Data

Following are the basic steps to connect to data in a database using dbExpress:

  1. On the Tool Palette, double-click the TSQLConnection component.
  2. In the Object Inspector, set the following properties for TSQLConnection:
    1. This app uses InterBase ToGo, so set the Driver property to IBLite/ToGo.
    2. Set the LoginPrompt property to False, so that the user is not prompted for a login.
    3. Click the ellipsis [...] for the Params property, and set the Database value to C:\Users\Public\Documents\RAD Studio\11.0\Samples\Data\dbdemos.gdb (location of the database); then close the dialog box:


    4. Set the Connected property to True.
      Note: If you get an error ("unavailable database") on development environment, this means you do not have a current license for InterBase. The license of InterBase Developer Edition is included as part of the product for some product editions. For more information, see Troubleshooting.
  3. Add a TSQLDataSet component to the form, and set the following properties:
    1. Set the SQLConnection property to SQLConnection1 (the one that you added in a previous step).
    2. Set the CommandText property to select COMMON_NAME, SPECIES_NAME from BIOLIFE order by COMMON_NAME.
    3. Set the Active property to True.
  4. Open the LiveBindings Designer and connect the data and the user interface as follows:
    1. Click COMMON_NAME in BindSourceDB1, and drag the mouse cursor to Item.Text in ListBox1.


    2. Click SPECIES_NAME in BindSourceDB1, and drag the mouse cursor to Item.Detail in ListBox1.

    Deploying your Application to iOS

Up to this point, you have used InterBase on your desktop. This means that the actual database is located at your local hard disk drive (for example, C:\Users\Public\Documents\RAD Studio\11.0\Samples\Data\dbdemos.gdb). On the iOS Device, the application is sand