As mentioned, Mimer SQL Mobile includes a development environment. For example, Mimer SQL Mobile for Windows Mobile or Symbian includes a Windows based (NT, 2000 or XP) development environment where you, together with Microsoft's embedded tools and Visual Studio 2005, can develop database applications for mobile devices. Usually the developed application can be verified in an emulation environment on the workstation before it is transferred to the target hardware device.
For Windows Mobile based devices Microsoft Visual Studio 2005 should be used.
You can develop applications using an API of you choice, for example JDBC, ODBC or Embedded SQL.
In the development environment all the database objects are created, including the statements used to access data when operating on the device. A statement in this sense is a database object holding a predefined SQL statement (see xxx). The statement can then be executed on the device. These statements can be static or dynamic. In the dynamic case, variables are used to couple the statement to the application. The database, including the statements, is then exported to the handheld device.