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
Advantage Delphi OData Client
As described here, the Advantage Web Platform enables all kind of applications to access ADS data without the need of using the Advantage Client Engine. In Delphi, you can simply use an HTTPRequest to interact with ADS. But – as
Advantage Web Platform
Beginning with version 11, Advantage ships the Web Platform, a web service that allows applications to communicate with Advantage Databases without having a specific Advantage Client Engine (ACE) available. The ACE is only available for Windows and Linux. Using the
Using ADS with Delphi 10.1 Berlin
As of today, Delphi’s latest edition 10.1 Berlin is not supported by SAP’s Advantage Database Server Delphi Client (V12). But there are a lot of ADS developers out there who want to use the latest version. As in the past,
Happy anniversary, ADS
In preparation to a session at the german Xbase user group meeting I realized a nice detail about Advantage Database Server. In 1991 Extended Systems released a software named ExtendBase. It was already version 2.0 – but the first version
Tutorial: using ADS with Lazarus
For a couple of years now, the Free Pascal RAD IDE Lazarus is well supported by Advantage Database Server. In this little tutorial I want to show how to use the actual ADS components in Lazarus. First of all, get
Drop all indexes for a given table
There was a question in the german Xbase++ Forum how to drop all indexes for a given table in ADS if the table is part of a data dictionary (just deleting the index file won’t work in that case). The