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 883 0
0
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 1117 0
0
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 1248 0
0
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 1029 0
0
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 1364 0
0
