[yunqa.de] Re: More on DISqlite demos
- From: "IDT Maurits van Rijnen" <maurits.van.rijnen@xxxxxxxxxxxxxx>
- To: <yunqa@xxxxxxxxxxxxx>
- Date: Wed, 14 May 2008 11:41:15 +0200
We have made our own rapper for this, example:
MyQuery : TDisqlite3Query;
begin
MyQuery := NewQuery();
try
try
MyQuery.SQL.Text := 'SELECT aaa,bbb FROM tb_zzz WHERE yyy=:yyy AND
xxx=:xxx';';
MyQuery.ParamByName('yyy').AsString := 'justavalue';
MyQuery.ParamByName('xxx').AsString := 'justanothervalue
MyQuery.Active := true;
if not MyQuery.Eof then
begin
...
...
end;
except
on e: exception do
...........
finally
MyQuery.Free;
end;
________________________________
Van: yunqa-bounce@xxxxxxxxxxxxx [mailto:yunqa-bounce@xxxxxxxxxxxxx]
Namens Edwin Yip
Verzonden: woensdag 14 mei 2008 4:49
Aan: yunqa@xxxxxxxxxxxxx
Onderwerp: [yunqa.de] Re: More on DISqlite demos
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
Other related posts:
