View source for IBX.InterBase ToGo Sample

__TOC__

This sample shows how to monitor trace flags on an InterBase database connection. It requires InterBase to be installed on the machine or to connect to a remote server. Make sure that the [[rad_en:InterBase|InterBase server is running]] before you run the example. 

==Location==

You can find the '''Monitor Demo''' project at:
* {{SamplesMenu}} and then navigate to '''CPP\Database\IBX\InterBaseToGo'''.
* '''Subversion Repository for C++:''' {{CppSamplesUrl}}/Database/IBX/InterBaseToGo/

==Description==

This sample has two [[lib_en:FMX.Grid.TStringGrid|TStringGrid]] components. The grid on the top shows the content of the '''Customer''' table from the '''Employee''' database. The lower grid is related to the grid on the top, and it shows all the records from the '''Sales''' table associated with the selected customer. 

This sample runs on Win32, Win64, and on Mac OSX versions starting with 10.9.

==How to Use the Sample==

# Navigate to the location given above and open:
#* '''CppIBToGoDemo.cbproj'''
# Press '''F9''' or choose {{menu | Run &gt; Run}}. 
# Select the '''Employee GDB''' check  box to connect to the database.
# Use the navigators to go through the records of the grids.

==Files==

{| border="1" frame="hsides" rules="rows" frame="hsides" rules="rows"
! ''' File in C++
! ''' Contains '''
|-
| align="left" valign="top" |
'''CppIBToGoDemo.cbproj'''
| align="left" valign="top" |
The project itself.
|- 
| align="left" valign="top" |
'''MainForm.cpp/dfm'''
| align="left" valign="top" |
The main form and the code to give the functionality to the sample.
|}

==Implementation==

This sample uses a [[lib_en:IBX.IBDatabase.TIBDatabase | TIBDatabase]] component to connect to the '''EMPLOYEE.gdb''' database, which is available in the '''{{DataSamplesPath}}''' directory.

The relations on the different database components are created using LiveBindings. Select {{menu | View &gt; LiveBindings Designer}} to open the [[rad_en:LiveBindings Designer|LiveBindings Designer]] pane where you can see the bindings between the components. You can also see the relations in the [[lib_en:Data.Bind.Components.TBindingsList | TBindingsList]] component, this component is automatically added to the project once a relation using [[rad_en:LiveBindings in RAD Studio | livebindings]] is created. 

The [[lib_en:Data.Bind.DBScope.TBindSourceDB | Data.Bind.DBScope.TBindSourceDB]] is a nonvisual component that appears automatically after creating the binding.

The [[lib_en:Data.Bind.DBScope.TBindSourceDB | Data.Bind.DBScope.TBindSourceDB]] allows the connection between the [[lib_en:IBX.IBCustomDataSet.TIBDataSet | IBX.IBCustomDataSet.TIBDataSet]] and the access components: [[lib_en:FMX.Grid.TStringGrid | FMX.Grid.TStringGrid]] and [[lib_en:Fmx.Bind.Navigator.TBindNavigator | Fmx.Bind.Navigator.TBindNavigator]].

Right-click the IBDataSet1 component and click '''Edit SQL''' to see the SQL query that the dataset is using to show the data. The IBDataSet2 creates the relation between the two tables with the SQL Query: "select * from sales where Cust_No = :Cust_No".

==Uses==

* [[lib_en:IBX.IBDatabase.TIBDatabase | IBX.IBDatabase.TIBDatabase]]
* [[lib_en:IBX.IBCustomDataSet.TIBDataSet | IBX.IBCustomDataSet.TIBDataSet]]
* [[lib_en:IBX.IBDatabase.TIBTransaction | IBX.IBDatabase.TIBTransaction]]
* [[lib_en:Data.Bind.DBScope.TBindSourceDB | Data.Bind.DBScope.TBindSourceDB]]
* [[lib_en:Fmx.Bind.Navigator.TBindNavigator | Fmx.Bind.Navigator.TBindNavigator]]
* [[lib_en:FMX.Grid.TStringGrid | FMX.Grid.TStringGrid]]
* [[lib_en:Data.Bind.Components.TBindingsList | Data.Bind.Components.TBindingsList]]

==See Also==
* [[rad_en:Getting Started with InterBase Express | Getting Started with InterBase Express]]
* [[rad_en:View Various Tables (IBX General Tutorial) | View Various Tables (IBX General Tutorial)]]
* [[rad_en:Add a Data Module (IBX General Tutorial) | Add a Data Module (IBX General Tutorial)]]
* [[rad_en:Add Database Components (IBX No Code Tutorial) | Add Database Components (IBX No Code Tutorial)]]
* [[rad_en:Tutorial: Linking Controls via LiveBindings Designer | Tutorial: Linking Controls via LiveBindings Designer]]
* [[IBX.AdminTool Sample]]
* [[IBX.IBMastApp Sample]]
* [[IBX.MtsPool Sample]]

[[Category:C++]]
[[Category:Sample]]
[[Category:XE6]]