For a true unique primary key in a distributed environment, AUTOINC does not work well. So I always recommended to use either an AUTOINC combined with some kind of SiteId, or to use a GUID (global unique identifier). Prior to
First look at ADS 12
Without any public beta or pre-announcement, the most recent version of Advantage Database Server was released on October 21st 2015. This is the first version released after a new team took over the development in 2014. The list of enhancements
Get physical data path in ADS
Some server management function in Advantage Database Server require the physical file name of the table including the local path. One example could be to get all users of a specific table so you can disconnect them if you require
Insert Only
I’m currently attending the online lecture ‚in memory computing‘ by http://openhpi.com. One of the founders of SAP, Hasso Plattner, stated that they use insert only approach to keep a history of the record in the table. Since only ~10% of
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
Automatically load 32 or 64 Bit Advantage Extended Procedures
With the release of Advantage Database Server 10 back in 2010 the API for 64Bit clients was added. The latest patches (10.10.0.28) now also supports Delphi XE2 and with that Delphi developers can write Advantage Extended Procedures (AEP) for 64Bit
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:
Connecting a TAdsConnection Component using a connection string
The Advantage client Engine 10.1 introduced new API calls. One of them, AdsConnect101, can connect to a database using a connection string rather than setting the connection options one by one. TAdsConnection is able to hook into such a connection,