Working with Databases in SenseTalk Scripts

The eggPlant Functional application and SenseTalk scripting language integrates and communicates with several databases. The information shown in this section explains the details of how to use eggplant Functional and SenseTalk to integrate and communicate with these databases.

A database is a repository for storing information in a structured fashion. In a traditional relational database data is stored in tables. The information in each table is organized in rows and columns with each row holding one record. The columns in the table identify the different fields of information that are contained in each record.

For example, in a table for information about the members of a club, the columns might be first name, last name, member number, birth date, and so on. The table would contain one row (one record) for each club member.

firstName

lastName

memberNumber

birthDate

memberSince

expirationDate

Erica

Grayson

102

1982-07-02

2003

2014-08-05

Carol

Weinhart

48

1967-10-14

1999

2011-12-31

Ted

Hanover

186

1974-03-22

2010

2013-09-18

Justin

Fallcourt

171

1991-11-30

2009

2014-01-31

...

...

...

...

...

...

A database often contains many different tables holding different types of information. Typically a database is managed by a database server, which may be a process on the local computer, but is more often a central server available somewhere on the network.

In many cases, a single database server will hold many different databases, sometimes also called a schema. Each database schema defines a number of different tables.

Using SenseTalk with Databases

The eggPlant Functional application and SenseTalk scripting language integrate and communicate with databases. Read the following information to better understand how you can use SenseTalk to work with databases.

Database Connections: To work with a database first requires establishing a connection to communicate with the database server. Read this information to understand the details about establishing a connection to the database server.

Opening and Closing Connections: SenseTalk automatically opens database connections and closes them after the connection is no longer required. Read this information to understand how to explicitly open and close database connections.

ODBC Administration: Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). Read this information to understand the details of eggPlant Functional's support for ODBC.

Working with Excel: You can use SenseTalk to access data stored in a Microsoft Excel (.xlsx) format. Read this information to understand the details of using SenseTalk with Excel data.

Using and Maintaining Databases: Database record maintenance is an important activity when considering the daily requirements for keeping a database up-to-date. Read this information to understand database record maintenance.

Where Expressions: Where expressions are used to select the desired records from a table when using the record or records function, the number of records function, or the delete command. Read this information to understand where expressions.

Variations and Additional Information: There are other techniques for accessing database information. Read this information to understand these other techniques.

Database Identifiers: When a database connection is opened, either explicitly by an open database command, or automatically when needed, a unique identifier is assigned to it. Read this information to understand how to work with these unique identifiers.

Database Information Functions: SenseTalk relies on functions to get additional information about a database, table, or the database types that are available. Read this information to understand how to use these functions.

Executing SQL Directly: For users experienced with SQL databases, an executeSQL() function is available to run any SQL statement directly. Read this information to understand how to use this function to run SQL statements directly.

 

This topic was last updated on April 12, 2018, at 09:32:26 AM.

Eggplant icon Eggplant.io | Documentation Home | User Forums | Support | Copyright © 2018 Eggplant