I was reported that the Advantage Delphi client doesn’t return NULL on MONEY data type in Delphi Tokyo. After some research, I’ve found a bug in adsdata.pas: Line 5996 compares the data buffer with the value that represents NULL in
ADS Intensiv Workshop
Am 4. Mai 2017 veranstalte ich einen ADS Intensiv Workshop. Es sind nur noch wenige Plätze frei. Wer Interesse daran hat, bitte bis spätestens 1. April 2017 anmelden, da ich die endgültige Teilnehmerzahl dem Hotel melden muss. Details zum Workshop
ADS and Delphi 10.2 Tokyo
The next version of Delphi will be released soon – and there’s again the question if SAP will support ADS for the upcoming version. Personally I wouldn’t bet on it. But it’s quite easy to get the packages compiled by
How to get rid of the ADS SQL Editor in Delphi
A user reported via a forum that he has some issues with the built in SQL editor of the TAdsQuery component. In most cases the complete IDE just freezes. The easiest solution is to get rid of that editor. Launch
Dynamically loading Functions in Delphi
While working on the Advantage Client Library (ace.pas) to make it compatible with the latest Delphi version I found out that following does not work for Linux: „delayed“ is an unknwon keyword for the Linux compiler and even when commenting
Quick-Tipp: Load Images from file into ImageList
I was in need to load the images for a TImageList (in this example TPngImageList) from the file system at runtime. To prevent reinventing the stupid work every time I just created a class helper. Here’s the code: Usage:
Enhance TAdsQuery to include Query Callback
In the recently published blog article (Query Progress Callback) I’ve showed how to implement a query callback. For that example I’ve passed a pointer of the form into the callback function, requiring a unique callback function for every Formclass to
Query Progress Callback with Delphi
Today I want to focus on a topic that I was asked for many times: How can we get the progress of a running query and how can we even cancel it? Advantage Data Architect does it, so it should
Delphi Starter – and ADS?
For a couple of days Delphi starter was available for free from the Embarcadero Store at https://www.embarcadero.com/app-development-tools-store/delphi. A lot of developers from the Community asked me if the Advantage Database Server Components can be used with Delphi starter. In the
Delete Duplicated Records without having a Primary Key
During teaching a SQL class I was asked how to delete duplicated records from a table without having a primary key. Since they used Advantage Database Server, the answer was simple: Use the virtual column ‚ROWID‘ as primary key. For