"Tadeusz Gancarz" <
tgancarz@poczta.onet.pl> wrote in
news:tiy3m4zlxfof7wi.130220061502@ANDREA:
> 1. At "SQLSelect" no data are transfered to client until I Fetch
> record?
Yes
> 2. How Search() works at this two "SQLSelect" and "SQL
> DataSet". I tried demo version and in my opinion there wos no
> difffirence (time) for :locate() and :search().
I guess you mean :seek()... there is no :search() method.
You will need to try it on a large resultset. :seek uses a binary search
algorithm which means that the resultset must be sorted on the fields
that you are seeking on.
> 3. If :Append() is the same as SQL STATEMET "INSERT INTO ...." , and
> Update() == "UPDATE .....". I ask about it because of differences at
> SQL dialect (MySql, MSSQL, dB2..) . Simple question: if the same use
> of this SQLExpress method (the same Alsaka code)works fine at every
> RDMBs.
INSERT INTO and UPDATE are standard SQL ststements. They will work on
all database systems. You can also generate your own SQL statements.
In fact, there is no need to create a cursor just to insert or update
some data (doing this is highly inefficient).
> 4. I' m now at Alaska 1.82 version. If I buy such a version of
> SQlExpress what about version for 1.9 (I have a Alaska Prof.
> Subscripion ) ?
When you buy the product you get one year of support and software
updates. That includes updates for new versions of Xbase++.
> 5. What is a difference between ODBCDBE and SQlExpress?
SQLExpress has been available long before ODBCDBE. It is proven and
industry tested. SQLExpress provides you with finer control over the
data source and in addition you can always buy the 'enterprise' version
and get the complete source code.
Best regards,
Boris Borzic
--
news://news.Xb2.NET http://www.Xb2.NET http://www.SQLExpress.net industrial strength Xbase++ development tools