Elevate Software


Login Login

ProductsBulletSalesBulletSupportBulletDownloadsBulletAbout





Home » Elevate Software Blog

Icon Elevate Software Blog

Tags Showing all blog entries tagged with "ElevateDB"

Holiday Migration Promotion
Posted by Sam Young on Tue, Dec 4 2012

Happy Holidays! As a thank you for your continued support of Elevate Software, we are offering significant discounts when you migrate your DBISAM license to ElevateDB, as well as discounts for our current customers on the purchase of Elevate Web Builder.

Customers that currently own DBISAM Standard and DBISAM Standard With Source Code can migrate to the equivalent version of ElevateDB for $99.00.

Customers that currently DBISAM Client-Server and DBISAM Client-Server with Source Code can migrate to the equivalent version of ElevateDB for $159.00.

Customers that currently own either DBISAM or ElevateDB licenses can purchase Elevate Web Builder at the discounted price of $199.00.

To order ElevateDB, complete the following steps (please be sure that you are logged in to the web site with your user login information):
  • Visit the ElevateDB product page

  • Select your development environment from the list at the bottom of the page

  • Click on the Order Now link in the upper right area of the product information page

  • Add the desired product to your order, and select special offer code DBISAM-MIGRATE to apply your discount when adding the product to your order.
To order Elevate Web Builder, complete the following steps (please be sure that you are logged in to the web site with your user login information):
  • Visit the Elevate Web Builder product page

  • Click on the Elevate Web Builder for Web Application Developers link at the bottom of the page

  • Click on the Order Now link in the upper right area of the product information page

  • Add the desired product to your order, and select special offer code MIGRATE to apply your discount when adding the product to your order.
This pricing will be in effect until January 5, 2013.

Please contact me if you have any questions about this promotion.

Tags: ElevateDB, Elevate Web Builder, PromotionsPermanent Link0 Comments

ElevateDB 2.11 Build 2 Released
Posted by Tim Young on Wed, Nov 7 2012

ElevateDB 2.11 Build 2 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. This build contains bug fixes for several incident reports, which are detailed here.

Tags: ElevateDB, New BuildsPermanent Link0 Comments

ElevateDB 2.11 Released
Posted by Tim Young on Mon, Oct 8 2012

ElevateDB 2.11 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. You can view the release notes, including any breaking changes, on the download page before downloading.

This release includes support for Embarcadero RAD Studio XE3 and a new package naming convention to make referencing the ElevateDB runtime packages easier for VCL/FireMonkey applications and other design-time 3rd party packages.

Tags: ElevateDB, New ReleasesPermanent Link0 Comments

ElevateDB 2.10 Released
Posted by Tim Young on Sat, Sep 8 2012

ElevateDB 2.10 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. You can view the release notes, including any breaking changes, on the download page before downloading.

The catalog format/version number is not changed in this release, so you can simply recompile your applications in order to deploy the improvements and fixes contained in the release.

Text Index Bug
This release corrects a serious bug with the text indexes in ElevateDB that has been present since ElevateDB was originally released. The following incident report describes the issue:

# 3606 Text Indexes Containing Words Longer than Word Length Can Experience Corruption

This bug affects any database table that contains text indexes, and must be corrected in any affected database table immediately after installing 2.10. The following script can be run against any database using 2.10 in order to repair the text indexes:

SCRIPT
BEGIN
   DECLARE CatalogCursor SENSITIVE CURSOR FOR CatalogStatement;
   DECLARE DBPath VARCHAR DEFAULT '';
   DECLARE TableName VARCHAR DEFAULT '';
   DECLARE CurrentTable INTEGER DEFAULT 1;

   PREPARE CatalogStatement FROM 'SELECT * FROM Configuration.Databases WHERE Name=?';
   OPEN CatalogCursor USING CURRENT_DATABASE();

   FETCH FIRST FROM CatalogCursor ('Path') INTO DBPath;

   EXECUTE IMMEDIATE 'CREATE STORE __RepairTextIndexes AS LOCAL PATH '+QUOTEDSTR(DBPath);

   BEGIN

      PREPARE CatalogStatement FROM 'SELECT DISTINCT(TableName) FROM Information.Indexes
                                     WHERE Type=?
                                     ORDER BY TableName';
      OPEN CatalogCursor USING 'Text Index';
   
      SET PROGRESS TO 0;
      SET LOG MESSAGE TO '*** Repair of text indexes in database '+CURRENT_DATABASE()+
                         ' started on '+CAST(CURRENT_TIMESTAMP() AS VARCHAR);
   
      FETCH FIRST FROM CatalogCursor ('TableName') INTO TableName;
   
      WHILE NOT EOF(CatalogCursor) AND NOT ABORTED() DO
   
         SET STATUS MESSAGE TO 'Repairing text indexes for table '+TableName;
   
         EXECUTE IMMEDIATE 'DELETE FILE '+QUOTEDSTR(TableName+'.EDBIdx','"')+' FROM STORE __RepairTextIndexes';
         EXECUTE IMMEDIATE 'REPAIR TABLE '+QUOTEDSTR(TableName,'"');
   
         FETCH NEXT FROM CatalogCursor ('TableName') INTO TableName;
   
         SET PROGRESS TO TRUNC((CurrentTable/ROWCOUNT(CatalogCursor))*100);
   
         SET CurrentTable=CurrentTable+1;
   
      END WHILE;

   FINALLY
      EXECUTE IMMEDIATE 'DROP STORE __RepairTextIndexes KEEP CONTENTS';
   END;

   SET LOG MESSAGE TO '*** Repair of text indexes in database '+CURRENT_DATABASE()+
                      ' completed on '+CAST(CURRENT_TIMESTAMP() AS VARCHAR);

END

Warning A simple repair of the affected tables is not sufficient since the repair functionality in ElevateDB will not be able to cope with the shifted index key values in all cases. This is why the above script deletes the actual index file for the table before attempting to repair the indexes. If you are using a custom index file extension in your installations, please change the reference to '.EDBIdx' in the above script so that it matches the custom index file extension that you are using.

We sincerely apologize for this problem, and hope that it is not too disruptive for you or your customers.

Tags: ElevateDB, New ReleasesPermanent Link1 Comments

ElevateDB 2.09 Released
Posted by Tim Young on Mon, Jul 23 2012

ElevateDB 2.09 is now available for download. If you're an existing customer, then you should be receiving an email shortly with download instructions. You can view the release notes, including any breaking changes, on the download page before downloading.

The catalog format/version number is not changed in this release, so you can simply recompile your applications in order to deploy the improvements and fixes contained in the release.


Tags: ElevateDB, New ReleasesPermanent Link0 Comments

Product Status Update
Posted by Tim Young on Mon, Jun 18 2012

As you may already know, it's been very quiet around here lately. It tends to get that way when I've got a lot of development work to get done, and that's definitely been the case lately. The following will give you an idea of what I've been up to, as well as some information on what to expect for product releases in the next month.

Elevate Web Builder

I've finally finished up the coding on EWB (again). This round added the following enhancements, and will be the final release candidate as far as features are concerned:
  • The performance of the framework has been increased dramatically through a re-factoring of the way that the framework updates browser elements during control creation and resizing. In addition, BeginUpdate and EndUpdate methods have been added to both the TPanel and TForm controls to allow for suspending browser updates while creating or resizing many different controls at one time. All auto-create forms use these methods during initialization at application startup to drastically speed up the time it takes to create the forms and populate them with their design-time settings. Finally, the number of internal browser event handlers used for the TGrid control has been drastically reduced.


  • Both the TPanel and TForm controls now support automatic HTML form submittal. Building a submittal form is as simple as designing a form in the IDE and then calling a SubmitForm method at runtime. The IDE also logs all form submittals done through the IDE's local web server, allowing the developer the opportunity to view all form variables that were submitted for testing purposes. Finally, form submittals can be directed to a TPage control so that any output from a form submittal can be displayed to the end user, if so desired.


  • A new TFileUploadButton control for uploading files has been added, and it works seamlessly with the new form submittal functionality, and looks like a regular button on all browsers. When a file is selected via the button, an OnChange event is fired and the name of the file can be retrieved. This is useful for displaying the name of the file selected in a TEdit or TLabel control.


  • A new TSeparator control has been added for drawing separators or rectangles on forms or panels. Currently, you can only supply the fill color, but more properties will be introduced for borders, gradients, etc.


  • There is now date/time/number formatting functionality in the WebCore unit. The formatting is controlled via a global FormatSettings object that controls the short date and time formats, as well as the decimal separator for floating-point numbers. More formatting, including long date and time formats, will be provided as the product matures.


  • The following functions have been added to the built-in runtime: YearOf, MonthOf, DayOf, WeekDayOf, HourOf, MinuteOf, SecondOf, MSecondOf, TimeZoneOffset, EncodeDate, EncodeTime, EncodeDateTime, and StrReplace. Also, all date/time functions support a parameter for specifying whether local or UTC time is needed.


  • The TComboBox control now includes a Custom property that allows the developer to specify that a "..." custom button be used instead of a normal drop-down button with an arrow. When the user clicks on the custom button, an OnCustomClick event is fired for the control.


  • The TGrid control now includes a separator AllowAppends property to distinguish row appends vs. row inserts. Also, there is a new AlwaysShowEditor property that forces the editor to always be visible, a CustomCombo property for the grid columns and an OnCustomComboClick event for the grid to surface the above combo box functionality in the grid.


  • There is a new DataSet Manager in the IDE underneath the Project Manager that allows the developer to create datasets for use in the IDE during development (local web server usage required). Currently, you can define datasets for the ElevateDB and DBISAM database engines only, but more will be supported in the future. Once a dataset is defined, it can be dragged on to a form and dropped there, and all of the columns will automatically be defined for the dataset. The local web server in the IDE automatically knows how to respond to dataset requests for columns and rows, as well as the posting of transaction operations. This allows the developer to complete the full application development lifecycle without having to leave the IDE.


  • The dataset functionality has been enhanced significantly. There is now a new TDatabase component that controls all transactional operations across all datasets in an application, including new methods and events for starting, committing, and rolling back transactions. Nested transactions are supported now, which makes master-detail and multi-form database applications very easy to code. Also, loading a dataset is now as simply as a single TDatabase.Load method call, where the TDataSet instance is passed in to the method as a parameter. One can also use the TDatabase component to iterate over all datasets in the application. The TDataSet component now supports bookmarks with the SaveBookmark/GotoBookmark methods and includes the following new properties and events: AutoEdit, BeforeLoad, OnLoadError, AfterLoad, OnInitRow, and OnRowChanged.


  • There are a lot of new fixes that affect everything from the images to the grids to the compiler. I won't go into all of the details, but the main issues were with the tabbing/focusing in the framework and the way that the grid editors were working. The cache entries for the web browser are cleared when the application is run in the IDE, and that fixes a long-standing issue with the browser serving up cached versions of the application.
I've put together a couple of small videos that demonstrate the new DataSet Manager/dataset functionality and the form submittal functionality. You can see them here:

Elevate Web Builder DataSet Manager Demo

Elevate Web Builder Form Submittal Demo

ElevateDB

There are some neat new features coming up in a 2.09 minor release for ElevateDB:
  • There is a new CONTAINS ANY operator that performs an OR of the search words specified instead of the default AND of the search words. This really helps improve the performance of queries that used to be force to join a bunch of CONTAINS conditions with an explicit OR operator.


  • The performance of both the LIKE and CONTAINS/CONTAINS ANY operators has been greatly improved, especially for partial-word searches.


  • You can execute a CREATE TABLE statement with a new FROM UPDATES clause that allows you to dump the contents of any replication updates file (.EDBUpd) to a table in order to audit its contents. It works like this:

    CREATE TEMPORARY TABLE "updatestest" FROM UPDATES "MainOffice-2010-12-14 17-57-12.0306" IN STORE MainUpdates


  • There is an OnServerProcedureEvent event in the TEDBEngine component that allows you to define built-in custom server procedures that can handle custom requests from a remote session. The TEDBSession component includes a new RemoteParams property and CallRemoteProcedure method that provides the functionality for allowing a remote session to call a custom server procedure.


  • The ElevateDB Server now includes a "named server" architecture for running multiple instances of the ElevateDB Server on the same machine. This makes it possible to deploy a single edbsrvr.exe on a server machine and start up many instances of the ElevateDB Server, each with its own configuration. This applies to running the ElevateDB Server as a service also.
In addition to the above enhancements, there are several bug fixes that will be included also. Among these, there is an important fix for the 64-bit ElevateDB ODBC Driver that fixes a major issue with the driver when used with the 64-bit version of Microsoft Office 2010.

DBISAM

The major improvement coming up for DBISAM is the 64-bit DBISAM Database Server and an important fix for the 64-bit DBISAM ODBC Driver that fixes a major issue with the driver when used with the 64-bit version of Microsoft Office 2010 (same issue as with ElevateDB).


Tags: Elevate Web Builder, ElevateDB, DBISAMPermanent Link9 Comments


Previous Entries: 1-6 7-12 13-18 19-24 25-30 31-36 37-42 43-48 49-54 55-60 61-66 67-72 73-78 79-84 85-90 91-96 97-102 103-108 109-114 115-120 121-126 127-132
Image