Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread ENGINE or similar variable in SQL scripting
Wed, Jun 29 2011 6:28 AMPermanent Link

Adam Brett

Orixa Systems

Another thread has mentioned:

>>Each EDB engine instance has the ability to dish out a proper incrementing
>>64-bit timestamp that is loosely based upon the current timestamp
>>(date/time) and any interactions with other EDB systems via replication.
>>It's how EDB orders all insert/update/delete operations across the
>>distributed systems.

These useful "Lamport Timestamps" are not yet available to EDB programmers, but maybe could be.

I wonder whether there is a case to be made for the addition of an "ENGINE" key-word to EDB SQL?

This might surface the above variables, and might surface other features which are currently accessible via the EDBEngine component in Delphi but not directly via the SQL.
Thu, Jul 7 2011 11:38 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< These useful "Lamport Timestamps" are not yet available to EDB
programmers, but maybe could be.

I wonder whether there is a case to be made for the addition of an "ENGINE"
key-word to EDB SQL?

This might surface the above variables, and might surface other features
which are currently accessible via the EDBEngine component in Delphi but not
directly via the SQL. >>

Most of the engine information either isn't useful to an SQL script/routine,
or is already surfaced in another way, such as the QUOTEDSTR() function.  In
general, engine information is normally surfaced via the system information
tables, or via specific functions.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image