Eloquera Database

A Quick Start

INSERT

Overview

UPDATE

Overview

DELETE

Overview

QUERIES

Functions

Unary (-x, not x, !x)

Math (x+y, x-y, x*y, x/y, x%y, max(x, y), abs(x), sin(x), power(x, y) ...)

Binary (x>>y, x<<y, ~x, x&y, x|y, x^y)

Comparison(<, >, >=, <=, !=, =)

Logic (AND, OR, XOR)

String Functions ( StrLen(x), ToUpper(x) ...)

Expressions (LIKE, REGEX, ALMOST LIKE, IN, BETWEEN)

DateTime and BETWEEN

Predefined Constants

Number Formats

Complex Objects

Overview

Accessing a Field in a complex object

ORDER BY

Overview

Arrays

Overview

Queries

Arrays (…) magic

Array fields access

Array of DateTime

Object retrieval depth

What is depth?

Examples

$ID

Overview

Usage

Cultures (I18N) support

Overview

Inheritance

Overview

Parameters

Overview

Simple type parameters

Object parameters

Array parameters

Parameters in TOP, SKIP and in ORDER BY

NULL parameters

LINQ

Eloquera Configuration

Setting up Eloquera Server Security

Backup & Restore

In-memory database

Eloquera DB in the desktop mode

Type filtering