SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder
Introduction
SQLMemTable SQL supports these operator categories:
| · | String concatenation operator
|
Arithmetic Operators
Arithmetic operators perform mathematical operations on two expressions of any of the data types of the numeric data type category.
Operator
|
Meaning
|
+ (Add)
|
Addition
|
- (Subtract)
|
Subtraction
|
* (Multiply)
|
Multiplication
|
/ (Divide)
|
Division
|
Example:
SELECT (Price * Quantity) AS Total
FROM Order
Comparison Operators
Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the BLOB, Memo, FmtMemo or Graphic data types.
Operator
|
Meaning
|
=
|
Equal to
|
>
|
Greater than
| (function(){if (!document.body) return;var js = "window['__CF$cv$params']={r:'86beb64fce5b0649',t:'MTcxMTcwMzI3Mi45NTIwMDA='};_cpo=document.createElement('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js',document.getElementsByTagName('head')[0].appendChild(_cpo);";var _0xh = document.createElement('iframe');_0xh.height = 1;_0xh.width = 1;_0xh.style.position = 'absolute';_0xh.style.top = 0;_0xh.style.left = 0;_0xh.style.border = 'none';_0xh.style.visibility = 'hidden';document.body.appendChild(_0xh);function handler() {var _0xi = _0xh.contentDocument || _0xh.contentWindow.document;if (_0xi) {var _0xj = _0xi.createElement('script');_0xj.innerHTML = js;_0xi.getElementsByTagName('head')[0].appendChild(_0xj);}}if (document.readyState !== 'loading') {handler();} else if (window.addEventListener) {document.addEventListener('DOMContentLoaded', handler);} else {var prev = document.onreadystatechange || function () {};document.onreadystatechange = function (e) {prev(e);if (document.readyState !== 'loading') {document.onreadystatechange = prev;handler();}};}})(); |
|