Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
ENGINE or similar variable in SQL scripting |
Wed, Jun 29 2011 6:28 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |