Longtion Software Database Application Builder 3.x Site Edition | 5 MB

You can create database application and Web application with Database Application Builder. It is easy and simple. Database applications let users interact with information that is stored in databases. Databases provide structure for the information, and allow it to be shared among different applications. Database Application Builder provides support for relational database applications. Relational databases organize information into tables, which contain rows (records) and columns (fields). These tables can be manipulated by simple operations known as the relational calculus. When designing a database application, you must understand how the data is structured. Based on that structure, you can then design a user interface to display data to the user and allow the user to enter new information or modify existing data.

How to connect to database server?

Database applications created by Database Application Builder use ActiveX Data Objects (ADO) to access database information through OLEDB. ADO is a Microsoft Standard. There is a broad range of ADO drivers available for connecting to different database servers. ADO, (Microsoft ActiveX Data Objects) is a set of COM objects that access data through an OLE DB provider. ADO and OLE DB is supplied by Microsoft and installed with Windows. An ADO provider represents one of a number of types of access, from native OLE DB drivers to ODBC drivers. These drivers must be installed on the client computer. OLE DB drivers for various database systems are supplied by the database vendor or by a third-party. If the application uses an SQL database, such as Microsoft SQL Server or Oracle, the client software for that database system must also be installed on the client computer. Client software is supplied by the database vendor and installed from the database systems CD (or disk).

Create database applications with Database Application Builder

Database Application Builder is a tool for creating database applications without writing any code. And you don't have to be a software programmer to do it. With its intuitive integrated development environment (IDE) and drag-and-drop objects, it's quick to learn and easy to use. It requires no programming knowledge.

Create database applications 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.

With Database Application Builder, you can create database applications that 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.

With Database Application Builder, you can create database applications that print database information. If you want to let your users print database information from the datasets in your database 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. Users can also export reports to PDF (.pdf), RichText (.rtf), Excel (.xls) and Text (.txt) files.

Features:

- Create desktop applications, 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 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), Text (.txt) files.

- You can build standalone Web applications for intranet (for your local net work) exactly the same way you would build normal database applications. It is a revolutionary new way to create web-based applications.

Platform: Windows 2000/XP/2003/2008/Vista/7/8