If you’ve written an application using Advantage Local Server and want your application to run on another machine you have to distribute some files with your application. These files are Advantage’s API dlls, charset configs, and configuration file.

Lets check which files to be copied :

Read the rest of this entry »

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Read the rest of this entry »

If you’re searching for a database solution for your Delphi/Builder applications Advantage Database can be a good option.

I’ve using advantage local server for two years. It’s a very stable local server. It has most of the modern SQL features. It has a good table based encryption. ( With advantage local server you cannot only encrypt the table’s connection, you can encrypt datas that table has. So we can say it’s secure if our application is also secure ). The performance is supreme whether you’re running long, loooong, loooooooooong queries using multiple tables, lots of SQL functions, etc.

And two good points with Advantage. The producer of Advantage, Sybase iAnywhere distributes a program for doing all the of the operations over local tables (creating,manipulating,running queries, etc) with a user friendly gui. Additionally they distribute Delphi/Kylic/Bc++ components for doing all of the operations on tables.

Lets write some advantages of the advantage local server :

Read the rest of this entry »