🚀 go-pugleaf

Christian,

An addition: You could use the SELECT-statement to check if the record you
want to add already exists:

int NEW_ID = 99;
...
AdoDataSet->CommandText = "SELECT * FROM CUSTOMER WHERE CUST_ID = NEW_ID";
AdoDataSet->Open();
if (!AdoDataSet->Eof) {.....}

Just an idea.
--
HTH

Ronald Loonstra
CodeFit Applications
www.codefit.nl

"Georgi Cholakov" <georgi.cholakov@mail.bg> schreef in bericht
news:3d195aad_2@dnews...
> Hi, Christian
> I saw the recommended tricks, but in my modest opinion they are useless or
> difficult to use. I think the reason for delay is in your SELECT
statement,
> because you first select all the data from the table Customer and then
> insert a new record. If you optimize your select to return a small number
of
> records the delay will be minimized.
> Try this: "SELECT * FROM CUSTOMER WHERE CUST_ID = 0" for example, where
> CUST_ID is the name of the primary key. This statement will return no
> records and it will be fastest & simplest way for your case.
>
> Georgi Cholakov
>
> "Christian Schneider" <csname@hotmail.com> wrote in message
> news:3d16bf57$1_1@dnews...
> >
> > I just want to add a record to a table. I am now
> > using something like this:
> >
> > AdoDataSet->CommandText = "SELECT * FROM Customer";
> > AdoDataSet->Open();
> > AdoDataSet->Insert();
> > AdoDataSet->FieldByName(...) = ...
> > AdoDataSet->Post();
> > AdoDataSet->Close();
> >
> > The problem is, that Open() can take very long if the
> > table is large. It would be much faster to use an
> > "INSERT INTO"-Statement, but I can't use it because
> > my record contains BLOB-Fields.
> >
> > It there really no other way to just add
> > a record to a table without waiting several seconds?
> >
> >
> > Christian Schneider
>
>
>
>