category:Database

esProc Accesses Databases: Updating Data

Besides being used to query data in a database, SQL is also used to update them. In esProc, you can use the SQL commands directly to return a query result, or use update function to modify a database with the data from a table sequence or a sequence. 1. Update a database with SQL commands In esProc, db.execute(sql) fun...

2015-01-12 26 0 0

esProc Accesses Databases: Data Connection Management

During our dealing with the database transactions, some operations may produce errors which could bring unexpected results, particularly during batch processes. In order to prevent this from happening, we need to manage the data connection in a right way and handle those errors properly. 1. Database error messages Firs...

2015-01-06 32 0 0

esProc Accesses Databases: Using SQL

In esProc, we can use not only the SQL to retrieve data from databases, but also the preliminary database query results to perform further analyses and operations to solve some complicated problems which are difficult to deal with in SQL alone. 1. Database connection and disconnection When SQL accesses databases, it sh...

2014-12-30 32 0 0

esProc Accesses Databases: Calling Database Stored Procedures

Besides data tables, store procedures are also very important for a database. esProc can call database stored procedures conveniently. This article will illustrate in detail how to call various stored procedures with db.proc() function in esProc.  1. Call stored procedures without return values Stored procedu...

2014-12-23 43 0 0

esProc Accesses Databases: Database Configuration

esProc supports a variety of heterogeneous datasources, including the databases. This article will introduce the methods of esProc’s connection to various databases. 1. Configure datasource manager To connect to a relational database, please follow these steps: 1) Click Datasource connection on Tool options menu to ope...

2014-11-26 41 0 0