Icon ElevateDB 2.27 Released

Posted by Tim Young on Thu, Jan 11 2018
ElevateDB 2.27 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions.

The complete list of breaking changes and new features is below.

2.27 Breaking Changes
The following are breaking changes in 2.27:
  • The XML output from the EXPORT TABLE SQL statement now includes a top-level "table" element in order to properly adhere to the XML specifications and allow exported XML files to be properly validated.

    Information The IMPORT TABLE SQL statement can still import XML files formatted with or without the top-level "table" element.


  • Comparisons between timestamp values and date values now ignore the time portion of the timestamp value and only compare the date portion of the timestamp value with the date value. This means that you can now execute queries like the following:

    SELECT * FROM MyTable WHERE TimeStampColumn = DATE '2017-10-17'

    and the query will return all rows where the TimeStampColumn column contains a timestamp value whose date portion matches the specified date constant value.


  • As indicated in incident report #4609:

    # 4609 Default Expressions for DECLARE SQL/PSM Statements Not Being Properly Type-Checked

    default expressions for DECLARE SQL/PSM statements were previously not being type-checked properly, so you may see new type errors during compilation of routines that do not specify correct default expressions for a given variable type.
2.27 New Features
The following are the new features in 2.27:
  • New VCL TEDBDataSet Import and Export methods have been added to allow for the import/export of files to/from TEDBTable, TEDBQuery, TEDBScript, and TEDBStoredProc components.


  • A new LOG EVENT SQL/PSM statement has been added in order to allow SQL/PSM routines (scripts, procedures/functions, triggers, and jobs) to log information, warning, and error events directly to the logged events for the current ElevateDB configuration.


  • There are new VCL TEDBEngine AddDayTimeToDateTime, AddDayTimeToTime, AddYearMonthToDate, AddYearMonthToDateTime, SubtractDateFromDateAsDayTime, SubtractDateFromDateAsYearMonth, SubtractDateTimeFromDateTimeAsDayTime, SubtractDayTimeFromDateTime, SubtractDayTimeFromTime, SubtractTimeFromTimeAsDayTime, SubtractYearMonthFromDate, and SubtractYearMonthFromDateTime methods that allow for basic interval math directly from native code, in addition to SQL.


  • As noted above in the breaking changes section, you can now directly compare the date portion of timestamp values with date values.


  • ElevateDB now logs warning events to the logged events for the current ElevateDB configuration when a database is opened and the database path does not exist, or if the database catalog does not exist.


  • The ALTER INDEX and ALTER TEXT INDEX SQL statements no longer alter the entire index when only the description is changed.
In addition, this release contains several bug fixes, which are detailed here.

Tags: ElevateDB, New ReleasesPermanent Link

Comments Comments (3) You must be logged in to comment

Comment caicai2017 said... Reply
Liderando la forma este fin de semana con el mejor lanzamiento de los próximos dos días será Jordan Brand con el regreso del popular Air Jordan 5 Retro. Otro zapato que vale la pena destacar será la colaboración más reciente de Converse con Tyler, The Creator en las zapatillas One Star.
La mayoría de [url=http://www.rostfriaarbeten.se/Nike-Air-VaporMax-Dam-c-17_18.html]Nike Air VaporMax Dam[/url] los lanzamientos de zapatillas deportivas del último fin de semana se [url=http://www.rostfriaarbeten.se/Nike-Air-Max-90-Essential-Dam-c-73_74.html]Nike Air Max 90 Essential Dam[/url] agotaron rápidamente. Dicho esto, aquí están las cinco mejores selecciones de [url=http://www.jwrennie.co.uk/nike-air-huarache-c-1/nike-air-huarache-womens-c-1_3/]Nike Air Huarache Womens[/url] zapatillas del fin de semana de XXL que estarán disponibles en tiendas selectas y, [url=http://www.rostfriaarbeten.se/Nike-Air-Max-2017-Dam-c-35_36.html]Nike Air Max 2017 Dam[/url] por supuesto, en línea. Eche un vistazo a la galería de abajo. Ser parte de la familia adidas sin duda puede ayudar cuando se trata de flexionar para el Gram, solo solicite G.O.O.D. El presidente musical, Pusha T, quien colocó un par de zapatillas Friends and Family adidas EQT King Push en su IG anoche. Mostrando una iteración inédita nunca antes vista de sus agotadas patadas King Push, el rapero de Virginia les dio a sus seguidores una mirada detallada de los zapatos con su breve provocación.
Vestido con una parte superior blanca, grisácea y crema, Friends and Family King Push EQT presenta una parte superior PrimeKnit con un efecto a escala y tecnología Boost en la entresuela, [url=http://www.annieleibo.cz/nike-air-max-270-c-52/nike-air-max-270-d225msk233-c-52_53/]Nike Air Max 270 Dámské[/url]seguida de una suela blanca para completar el aspecto de la zapatilla.[url=http://www.rotulosalbir.es/Adidas-Superstar-Mujer-Rosa-c-13_18.html]Adidas Superstar Mujer Rosa[/url]


Una filial desde hace mucho tiempo de la marca adidas, Pusha T, ha sido parte [url=http://www.annieleibo.cz/nike-air-max-97-c-59/nike-air-max-97-d225msk233-c-59_60/]Nike Air Max 97 Dámské[/url] del aumento de la marca en la cultura hip-hop junto con su compa?ero G.O.O.D. Socio de música Kayne West. Al asociarse con la marca en varias collabs de calzado, Three Stripes y King Push han podido lanzar tres siluetas exitosas en los últimos dos a?os.

Mientras que las noticias sobre el lanzamiento de una nueva colaboración Pusha T x adidas aún no se han anunciado, la burla de Pusha T anoche deja a los fanáticos de la moda especulando sobre la posible colaboración. Hoy, adidas Athletics continúa su asociación con Reigning Champ presentando la última colección de colaboración a través de un lookbook completamente nuevo con el mariscal de campo estrella de la NFL, Dak Prescott, [url=http://www.rostfriaarbeten.se/Nike-Free-Run-2.0-Dam-c-98_99.html]Nike Free Run 2.0 Dam[/url] y la súper modelo Indyamarie Jean. Comprometida con una amplia gama de [url=http://www.rostfriaarbeten.se/Nike-Air-Zoom-Pegasus-35-Dam-c-89_90.html]Nike Air Zoom Pegasus 35 Dam[/url] prendas de vestir y calzado para hombres y mujeres, la colección se mantiene [url=http://www.rostfriaarbeten.se/Nike-Air-Max-98-Dam-c-79_80.html]Nike Air Max 98 Dam[/url] fiel a la artesanía y la estética de Reigning Champ.
La nueva entrega de RC y adidas incluirá nuevas ediciones de las siluetas de Pure Boost y Alphabounce de adidas. El gris circular de punto moteado Pure Boost presenta un forro y tacón de cuero en el talón, mientras que el Alphabounce gris claro tiene un forro de calcetín de cuero y ojales, y malla de ingeniería te?ida en el espacio.

Comment caicai2017 said... Reply
Sneaker [url=http://www.annieleibo.cz/nike-air-max-97-c-59/nike-air-max-97-d225msk233-c-59_60/]Nike Air Max 97 Dámské[/url] authority Nice Kicks and adidas are opening a joint retail store in Los Angeles on February 10, and in celebration of the event, the collaborative duo is launching a four-day chase in [url=http://www.jwrennie.co.uk/nike-air-max-command-c-36/nike-air-max-command-womens-c-36_38/]Nike Air Max Command Womens[/url] LA starting on February 7. The giveaway event will offer [url=http://www.rostfriaarbeten.se/Nike-Free-Run-2.0-Dam-c-98_99.html]Nike Free Run 2.0 Dam[/url]fans a chance to win some “crazy adidas prizes,” which will surely include some high-demand sneakers.

To tease the event, Nice Kicks took to Instagram to preview some of [url=http://www.rostfriaarbeten.se/Nike-Air-Max-2017-Dam-c-35_36.html]Nike Air Max 2017 Dam[/url] the upcoming giveaway prizes, which includes: the Nice Kicks x adidas Consortium NMD Runner PK (pictured above), the upcoming Pharrell x adidas NMD Hu Trail “Blank Canvas,” the adidas Crazy BYW, the Packer Shoes x Solebox “Silfra Rift” from the adidas Consortium Sneaker Exchange and a slew of UltraBOOST models.

Take a look at Nice Kicks’ teaser video [url=http://www.jwrennie.co.uk/nike-air-max-2017-c-16/nike-air-max-2017-womens-c-16_18/]Nike Air Max 2017 Womens[/url] below, mark your calendars for February [url=http://www.annieleibo.cz/nike-air-max-95-c-20/nike-air-max-95-daacutemskeacute-c-20_21/]Nike Air Max 95 Dámské[/url] 7 if you’re in LA and stay tuned for more details. For more high demand sneakers, adidas announced a FUTURECRAFT 4D “Ash Green” relaunch.oday, adidas Athletics continues its partnership with Reigning Champ by introducing the latest collaborative collection via a brand new lookbook featuring NFL star quarterback Dak Prescott and [url=http://www.annieleibo.cz/nike-air-presto-c-44/nike-air-presto-daacutemskeacute-c-44_45/]Nike Air Presto Dámské[/url] super model Indyamarie Jean. Compromised of a wide range of apparel and footwear for men and women, the collection stays true to [url=http://www.jwrennie.co.uk/]www.jwrennie.co.uk[/url] Reigning Champ’s craftsmanship and aesthetic.
The brand new drop from RC and adidas will include new editions of adidas' Pure Boost and Alphabounce silhouettes. The circular knit speckled grey Pure Boost features a leather sock liner and heel, while the light grey Alphabounce features [url=http://www.rostfriaarbeten.se/Nike-Air-Max-Zero-Dam-c-53_54.html]Nike Air Max Zero Dam[/url] a leather sock liner and eye-stays, and space-dyed engineered mesh.
The collaborative apparel collection will feature a variety of product for both men and women and is compromised of the following items—jacquard bomber jackets, pullover hoodies, pants, tights [url=http://www.rotulosalbir.es/Adidas-ZX-Flux-Mujer-c-10_11.html]Adidas ZX Flux Mujer[/url] and crop tops for womeThe adidas x Reigning Champ apparel collection will launch globally starting this Friday, Aug. 25., at select adidas stores, adidas.com, Reigning Champ online and all Reigning Champ flagship stores.[url=http://www.jwrennie.co.uk/nike-air-max-90-c-19/nike-air-max-90-womens-black-c-19_26/]Nike Air Max 90 Womens Black[/url]  The footwear capsule will drop by the end of the month in the U.S. with the Alphabounce retailing for $140 while the Pure Boost will retail for a suggested price [url=http://www.jwrennie.co.uk/nike-dunk-sb-c-48/nike-dunk-sb-womens-c-48_50/]Nike Dunk SB Womens[/url] of $180 .n.

Comment caicai2017 said... Reply
Nike LeBron Watch programme a frappé avec un rythme furieux que la saison régulière de la NBA se termine, et la marque a déjà taquiné des images de la LeBron 15 "Griffey." Il est donc temps maintenant de laisser tomber le Préférable LeBron 15 x Air Griffey Max 1 -adhidid accessoirisé son ensemble en ajoutant une ceinture blanche à son short ainsi que d'une cha?ne de corps complexe, un chou blanc, des cadres rectangulaires minces et des boucles d'oreilles créoles.

La [url=http://www.wimatherm.de/nike-air-max-1-c-7/nike-air-max-1-damen-c-7_8/]Nike Air Max 1 Damen[/url] gagnante de l'Influenceur de l'année 2017 du FN a peaufiné sa [url=http://www.rostfriaarbeten.se/Nike-Air-Force-1-Dam-c-23_24.html]Nike Air Force 1 Dam[/url] tenue avec des montures oeil de chat bordées de blanc, des boucles d'oreilles ornées de perles et une [url=http://www.royerimprimeur.fr/Nike-Air-Huarache-Femme-c-22_23.html]Nike Air Huarache Femme[/url] sélection de bagues.

Romee Strijd, qui était également à la fête de Levi, portait un haut blanc avec un short en denim à lavis foncé et un blanc Dr. Martens avec des lacets noirs.
Avec le temps écoulé sur la saison régulière, le programme LeBron Watch peut avoir encore une chaussure de plus dans son arsenal dans le "Griffey".
Dans le cadre du programme LeBron Watch, Nike a James porter une chaussure édition spéciale joueur dans un jeu [url=http://www.annieleibo.cz/nike-air-zoom-spiridon-c-84/nike-air-zoom-spiridon-d225msk233-c-84_85/]Nike Air Zoom Spiridon Dámské[/url]avant d'ouvrir une fenêtre de 23 minutes pour les fans d'acheter la sneaker en édition limitée pour 200 $. Alors que la marque a montré quelques baskets LeBron-édition spéciale, le programme prévoit une variété de baskets à publier au public.
Fila [url=http://www.wimatherm.de/nike-air-vapormax-c-49/nike-air-vapormax-damen-c-49_50/]Nike Air Vapormax Damen[/url] ramène ses baskets Logo Mindblower 1995 et c'est complètement tendance
Desiree Linden remporte le marathon de Boston dans Brooks Sneakers
Le programme a débuté[url=http://www.amaryllis.es/Nike-Air-Max-95-Mujer-c-1_16.html]Nike Air Max 95 Mujer[/url]  en Janvier lorsque LeBron portait une espadrille inspirée par le Nike Waffle Trainer. Il a suivi avec le "[url=http://www.amaryllis.es/Nike-Air-Force-1-Mujer-c-1_3.html]Nike Air Force 1 Mujer[/url] Diamond Turf", "Mowabb", "Orange Box", "Air Max 95" et "South Beach". Les propres informations LeBron Watch de Nike comprend une photo de la "Griffey", ce qui rend la sneaker si probable appara?tra bient?t.
Les Cavaliers ont cinq matchs à disputer en saison régulière, dont un match à domicile le 3 avril contre les Raptors de Toronto, un match à domicile le 5 avril contre les Wizards [url=http://www.roberttrinick.co.uk/nike-air-presto-c-77/nike-air-presto-womens-c-77_78/]Nike Air Presto Womens[/url]de Washington et deux matchs la semaine [url=http://www.jwrennie.co.uk/nike-dunk-sb-c-48/nike-dunk-sb-womens-c-48_50/]Nike Dunk SB Womens[/url] suivante contre les New York Knicks, un au Quicken Loans Arena de Cleveland. et un au Madison Square Garden à New York. Si nous voyons le LeBron 15 "Griffey"[url=http://www.roberttrinick.co.uk/adidas-nmd-c-1/adidas-nmd-womens-c-1_3/]Adidas NMD Womens[/url] maintenant ou plus tard, cependant, reste une question.
Nike célèbre l'amour de LeBron James pour les cailloux fruités avec le LeBron 15 'Cereal'
Nike LeBron 15[url=http://www.rotulosalbir.es/Adidas-Ultra-Boost-Mujer-c-30_31.html]Adidas Ultra Boost Mujer[/url] 'Rust Pink' probablement une realité hollywoodienne

Image