Here are some key features of “Longtion Application Builder”:
– Create database application without writing any code. No programming experience is required.
– Connect to database servers. Create application that can create, restructure, fetch data from, update, and otherwise manipulate local (Paradox, dBASE, FoxPro, and Access) and remote database servers (Oracle, Sybase, Informix, Microsoft SQL server, and DB2). You can access a wide variety of database servers, using ADO or ODBC to connect to different databases.
– Connect directly to Microsoft Jet OLE Database (Access) database files.
– Create Microsoft Jet OLE Database (Access) database and create database tables.
– Provides a set of data-aware objects that represent data from fields in a database record, and, if the dataset allows it, enable users to edit that data and post changes back to the database. By placing data objects onto the forms in your database application, you can build your database application’s user interface (UI) so that information is visible and accessible to users.
– You can choose between objects that are designed to display and edit plain text, objects that work with formatted text, objects for graphics, multimedia elements, and so on.
– You can display information from a single record on the screen, or list the information from multiple records using a grid (DBGrid).
– You can let users navigate through the records of datasets and add or edit data. You may want to add your own objects or mechanisms to navigate and edit, or you may want to use a built-in object such as a DBNavigator.
– Create master/detail relationships. DBTable datasets can be linked into master/detail relationships. When you set up a master/detail relationship, you link two datasets so that all the records of one (the detail) always correspond to the single current record in the other (the master).
– Define lookup fields. You can define lookup fields for dataset object, DBQuery or DBTable. A lookup field is a read-only field that displays values based on search criteria you specify. In its simplest form, a lookup field is passed the name of an existing field to search on, a field value to search for, and a different field in a lookup dataset whose value it should display. For example, consider a mail-order application that enables an operator to use a lookup field to determine automatically the city and state that correspond to the zip code a customer provides. The column to search on might be called ZipTable.Zip, the value to search for is the customer’s zip code as entered in Order.CustZip, and the values to return would be those for the ZipTable.City and ZipTable.State columns of the record where the value of ZipTable.Zip matches the current value in the Order.CustZip field.
– Analyze and summarize information from databases so that users can draw conclusions from the data. The DBChart object lets you present database information in a graphical format that enables users to quickly grasp the import of database information. DBChart includes chart series types: Line, Area, Point, Bar, Horizontal Bar and Pie.
– Print database information. If you want to let your users print database information from the datasets in your application, you can use Report objects, visual report design objects. You can use Report objects to create a variety of reports, from simple banded reports to more complex, highly customized reports.
– Export report to PDF (.pdf), RichText (.rtf), Excel (.xls) and Text (.txt) files.
.
