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
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
Load CSV files into Advantage
Recently there has been a posting in the Advantage newsgroups (http://devzone.advantagedatabase.com/forum/questions/2339/any-similar-command-with-mysql-load-command-in-ads) that inspired me to write this blog post. A user asked on how he could load from a text file.
Get Advantage Versions in Delphi
Inspired by a question in the Advantage Database Forum I’ve extracted some functions from the Advantage Delphi Client Kit to get the version numbers.
German Soundex „Kölner Phonetik“ SQL implementation
To all my english fellows: Since the topic discussed in this article is for the german language only I’ll post it in german language. Sorry. Zur Ähnlichkeitssuche von Zeichenketten existieren mehrere Verfahren. Das bekannteste ist wohl Soundex, welches unter anderem
Adjusting Table Structure using SQL
I was asked by a partner how he could adjust his table structure. He needed to check if a char field is available and adjust its size to a minimum of 40 characters. So I came up with this script: