Re: Open or ExecSql ?

Open returns a result set.
Execute doesn't return, for example insert just puts the values in the
database and doesn't return any set back.
But select does returns something (even empty) back, and in this case open
should be used.

regards
George Christoforakis.


"Sergey" <sergey@xxxxxxxxxx> wrote in message
news:425a77f8@xxxxxxxxxxxxxxxxxxxxxxxxx
> In a adoQuery; How I can understand I must use Open or ExecSql.
>
> ****************************************
> Button1.Click
> ----------------------
> adoQuery1.Sql.Text := Edit1.Text;
>
> if adoQuery1.Sql.Text = "DML script (insert, update, delete)" then
> adoQuery1.ExecSql
> else
> adoQuery1.Open;
> ****************************************
>
>


.

Quantcast