Archive for the Category: Databases

Delphi and MySQL

August 29, 2011 Hugo Rosário

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 Delphi, 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

Fix “Key Violation” on Paradox tables.

January 31, 2011 Hugo Rosário

“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, Delphi, Paradox Tagged auto increment, delphi code, delphi programs, integer number, paradox table, paradox tables, primary key, violation error 9 Comments

How to open Access databases without Microsoft Access?

January 28, 2011 Hugo Rosário

A friend of mine just asked me if there was a way to open Microsoft Access databases without having Microsoft Access installed on the computer. His clients did not want to buy the Microsoft Office suite and he needed a simple and free solution. Share: Bookmark on Delicious Digg this post Recommend on Facebook share [...]

Also posted in Access, General Tagged customization tools, database management solutions, lightweight version, microsoft access databases, microsoft office suite, point users 1 Comment

How to repair a Paradox table?

January 25, 2011 Hugo Rosário

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 Delphi, 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 1 Comment