ABADev blog

Category: Soft/Programming

  • Paradox Direct Engine (ActiveX edition) v3.00

    Just now published the Paradox Direct Engine (ActiveX edition) v3.00
    http://www.scalabium.com/pdx/pdxa.htm

  • Excel Reader engine v3.0

    The new Excel Reader engine (dll edition) v3.0 with native xls-file parser is published and available for download.

    Now you may read the formulas (XLSIsCellFormula, XLSGetCellFormula, XLSGetCellFormulaLength functions),  ranges (XLSGetNamedRangeCount, XLSGetNamedRangeLength, XLSGetNamedRangeInfo functions), convert to text, html, xml, Excel xml and Lotus 1-2-3 formats

    Also the sample projects are updated and some new are added (for C#, for example).

  • XE8 support

    Embarcadero released the new RAD Studio XE8 and we added the support for this IDE.

    All our VCL components updated and new trial and registered archives are available for download and test.
    The shareware and freeware components released for XE8 (both Delphi and C++Builder).

  • Windows 7: weather gadget

    In February the weather gadget in sidebar stopped to work. I get the “cannot connect to service” error.

    If you have the same problem, you need change the date/time for config.xml file in C:\Users\<your account>\AppData\Local\Microsoft\Windows Live\Services\Cache folder.
    Just set the 01/01/2020 as date there.

    If you’re not developer and have no tools to change the date for file, you may do the next:
    – change the current date in Windows
    – open the config.xml in NotePad
    – without any changes in document you need save the file
    – return the real date in MS Windows
    – after a few minutes you’ll see the real weather in gadget

    PS: you do not need re-install anything or add any changes for DNS in hosts file as suggested in many sites. Just change the date of file and it’s enough for correct work.

  • Paradox Direct Engine (ActiveX edition) v2.95

    Paradox Direct Engine (ActiveX edition) v2.95
    http://www.scalabium.com/pdx/pdxa.htm

    The new SaveToXML method you may generate the xml-file which is compatible with .NET DataSet class.
    Now you may do not use the ado recordset and load the xml directly in Dataset().
    For example:

    // create unbound recordset for temporary storage (from Paradox table)
DataTable table1 = new DataTable("country");
table1.Columns.Add("Name");
table1.Columns.Add("Capital");
table1.Columns.Add("Continent");
table1.Columns.Add("Area");
table1.Columns.Add("Population");

DataSet set = new DataSet("map");
set.Tables.Add(table1);

// convert the records in Paradox table to xml-file
PdxViewA.TScalabiumParadoxReader pdx = new PdxViewA.TScalabiumParadoxReader();
pdx.FileName = Application.StartupPath + "\\country.db";
pdx.SaveToXML(Application.StartupPath + "\\country.xml", "country", false);
if (pdx.LastErrorMessage != null)
MessageBox.Show(pdx.LastErrorMessage);

//load converted xml into dataset
set.ReadXml(Application.StartupPath + "\\country.xml");

//view records in datagrid
dataGridView1.DataSource = table1;

  • SMMsg suite and time zone for dates

    Today I fixed the issue in SMMsg suite for dates in .msg-files. Now the dates processed and converted to local time zone correctly (function FileTimeToElapsedTime)

    The correct code is

      function FileTimeToElapsedTime(FileTime: TFileTime): TDateTime;
  var
    SystemTime, LocalSystemTime: TSystemTime;
    TZ: TTimeZoneInformation;
  begin
    Result := 0;
    try
      if FileTimeToSystemTime(FileTime, SystemTime) then
      begin
        if (GetTimeZoneInformation(TZ) <> 0) then
          if SystemTimeToTzSpecificLocalTime(@TZ, SystemTime, LocalSystemTime) then
            Result := SystemTimeToDateTime(LocalSystemTime);
      end;
    except
    end
  end;

  • mobile usability issues

    Google sent to me the notification to fix the mobile usability issues for blog.

    As I use the WordPress with standard classic theme, I upgraded the theme and installed the WPTouch plugin. Now no any errors detected there

  • Архитектура приложения

    http://habrahabr.ru/post/249453/

    Неплохая статья про трехуровневую архитектуру приложения (слой хранения=БД, слой бизнес логики=сервер приложений, слой UI=клиентские приложения).

    По крайней мере, автор на простом примере показал, почему нужно отталкиваться именно от бизнес процессов и БД проектировать уже в самом конце, а не основной упор делать на слое хранения.

  • Визуализация многомерных данных с помощью диаграмм Эндрюса

    http://habrahabr.ru/post/248623/

    Позволяет быстро найти “красную” группу, визуально выделяющуюся от остальных однотипных данных

  • Just now I released the new version 1.39 for MSGLibA/Message Reader Engine (ActiveX edition):

    http://www.scalabium.com/msg/msgliba.htm
    Now the compressed RTF body always processed without installed MS Outlook and winmail.dat files from Outlook 2010/2013 are supported too (RECIPTABLE attribute parsed)