Unanswered: Using Delphi's TClientDataSet - The basics, please.
I'm currently programming quite a large application using Delphi 7 Enterprise and my application is also in need of a database. Since the database only needs to run on a single machine (just a local database, nothing fancy), doesn't need to be that large and/or complex and since I don't want to use a server technology, I chose Delphi's TClientDataSet and file-based data storage (XML) as the way to go.
For some reason, though, I find working with the TClientDataSet extremely cumbersome (it's probably just me ;-)). It might have something to do with the fact that I've been using MySQL in conjunction with PHP for the last couple of years and it kind of grew on me. But since I didn't want to use any server technology, I discarded SQL as an option. So now I'm wondering how to do basic things like inserting, deleting, sorting records etc. with my TClientDataSet, things that went like a breeze when using MySQL (I must say that the way in which the "Using TClientDataSet"-help is organized within Delphi isn't quite that helpful).
So is there a tutorial out there somewhere that gets SQL-users up to speed as far as the usage of the TClientDataSet is concerned or is there some possibility of using SQL to access the TClientDataSet without having to rewrite large parts of my code (I've already created a lot of classes and auxiliary code for managing the TClientDataSets, so I don't want to abandon them)? Thanks in advance.