Create database applications and Web applications 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.
Define calculated fields. You can define calculated fields for dataset object, DBQuery or DBTable. A calculated field displays values calculated at runtime. For example, you might create a float field that displays values calculated from other fields.
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.
With Longtion Application Builder you can build standalone Web applications exactly the same way you would build normal database applications.
|70 + Visual Objects
Longtion Application Builder includes more than 70 built-in object types. You simply add them onto a form and then edit their ‘properties’ and ‘events’ to customize them however you want.
Panel, TabNotebook (and TabSheet), GroupBox, ScrollBox
Splitter, Button, ImageButton, Label, Image, Bevel, FadeButton, FadeLabel, Text, Shape, Balloon, Note, SlideShow, Edit, CheckBox, RadioButton, MaskEdit, SpinEdit, DateTimePicker, ListBox, ComboBox, Memo, RichText, ScrollBar, TrackBar, ProgressBar, MonthCalendar, ColorBox, TreeView, ListView, WebBrowser, MediaPlayer, FlashPlayer, PDFReader, ImageList, Timer
DBQuery, DBTable, DBNavigator, DBGrid, DBText, DBEdit, DBMemo, DBListBox, DBComboBox, DBRadioGroup, DBCheckBox, DBLookupListBox, DBLookupComboBox, DBRichText, DBImage, DBChart
Report, RepBand, RepSubDetail, RepLabel, RepDBText, RepDBRichText, RepDBImage, RepSUM, RepSysData, RepMemo, RepRichText, RepImage, RepShape, RepContainer
Add actions to handle application events, form events and object events, call global methods, object methods and define and call custom methods.
For power users, a full scripting language is available to add and edit actions.