Simon, I totally, completely agree with you! And this is exactly what I want! On Wed, May 14, 2008 at 1:40 AM, Simon Beesley <simonbeesley@xxxxxxxxxxx> wrote: > Hi, > > After thinking more about the question of learning to use DISQLite, I > came to the conclusion that what would be really useful would be a > single document explaining what the DISQLite equivalents are to TDataset > operations. > > I accept that creating DISQLite equivalents for TDataset components > (TTable and TQuery) would slow everything down. But it's still the case > that most people who have spent any time developing database > applications with Delphi will have a set of habits and expectations that > are hard to relearn. > > For example, with the Zeos components or ElevatesoftDB you can get the > data out of memo fields with a simple command like > > AStringvariable := FieldbyName('MemoField').AsString; > > With DISQLite3 it has taken me quite a long time to find out that I > should use the DiSQLStatement Column_str16 property (I am still not sure > whether this is the fastest method with DISQLite). I know that using > this with Prepare, Bind, and Reset is significantly quicker than using > AsString, but it would still be nice to be able to find these things out > more easily. > > Is there any chance of someone getting together a simple guide for > people like me who want to convert from TDataset type applications? > > Simon > > > > _______________________________________________ > Delphi Inspiration mailing list > yunqa@xxxxxxxxxxxxx > //www.freelists.org/list/yunqa > > > > -- Edwin Yip Best Regards, http://www.InnovationGear.com MindVisualizer -- Rapid Visual Mind Mapping Software