Archive for the Category: Delphi

Delphi and MySQL

When it comes the time for a developer to create good database applications that need interaction with database servers, one might think twice about using Delphi for this task, and they couldn´t be more wrong. There are tools for Delphi that simplify the process of connecting to the most known RDBM´s like MySQL, Microsoft SQL, […]

Also posted in Databases, MySQL, Programming Tagged database servers, delphi, delphi mysql, microsoft sql, ms sql server, oracle sybase, paradox database, sql postgresql, sql sybase, sybase oracle Leave a comment

ShellExecute in Delphi – Launch external applications.

Your Ad Here Executing external applications from Delphi can be very useful for a programmer. Imagine you want to call other applications from Delphi code, like backup utilities, text editors, music players, video players, word and excel documents, etc.. You can execute any external file by using the ShellExecute function present in the ShellApi library […]

Also posted in Programming Tagged backup utilities, code execution, data segments, delphi code, dynamic link library, enough memory, pchar, shellexecute, text editors, uses clause, win32 exe 15 Comments

Fix “Key Violation” on Paradox tables.

“Key Violation” errors occur whenever a new record is created with a primary key that already exists. This means that the field you defined as your primary key must be unique on the table. No other record can have that value, and it generates a “Key Violation” error when this happens. Share: Bookmark on Delicious […]

Also posted in Algorithms, Paradox Tagged auto increment, delphi code, delphi programs, integer number, paradox table, paradox tables, primary key, violation error 13 Comments

How to compress/decompress multiple files using Delphi 7?

Sometimes, Delphi 7 programmers need to implement some kind of compression/decompression features in their programs. Imagine you need to make a backup of files, like paradox databases or making an import/export feature that needs several files. The best way to do this is using compression tools to archive all the files into one single exportable […]

Also posted in Algorithms Tagged compression decompression, decompression features, delphi 7, paradox databases, zip ace 18 Comments

How to repair a Paradox table?

Your Ad Here I have a few projects in Delphi that use Paradox as database and sometimes I have to deal with corrupted tables or headers which is a real pain to solve. Anyway, here are some free tools to help you fixing the tables/headers of corrupted paradox tables or “Key Violation” errors. This application […]

Also posted in Paradox Tagged amp repair, BLOB, borland database, csv, Data, database desktop, delphi, Editor, HTML, pain, paradox, paradox table, paradox tables, password, PdxRepair, regener, RTF, some free tools, structure viewer, use 2 Comments