ExecSQL problem !!!!!!!!!!!!

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by alexandr Wed, 29 Nov 2000 21:35

#5955

Author: alexandr
Date: Wed, 29 Nov 2000 21:35

21 lines
1579 bytes

I'm using this peace of code:

 TADOQuery* qrTemp = new TADOQuery(this);
 qrTemp->ConnectionString = ReportQ->ConnectionString;
 String sql = "delete from Teable where ID = " +
  IntToStr(ID);
 qrTemp->SQL->Add(sql);
 try
 {
  qrTemp->ExecSQL();
 }
 catch(...)
 {
  ShowMessage("DELETE failed");
 }
 delete qrTemp;

but it seems to me that REAL delete of record occurs only after maybe 2 or 3
seconds, so if I'll perform immediately Select from database, than I'll see
the 'dead' record and only after second or third attempts it will be really
deleted. Could anyone explain this a situation.

Re: ExecSQL problem !!!!!!!!!!!!

#5961

Author: alexandr
Date: Fri, 01 Dec 2000 18:11

10 lines
1566 bytes

I'd like to define my question more precisely. I have the simplest
application, which has the form and a couple of ADO queries. The first is
connected to DBGrid on the form. Also I have a function Op() which performs
something like this "select * from table" using the first query. The second
ADO query was designed for Add operation. When I click appropriate button it
will perform "insert into table" operation using second ADO query and then
invoke the same Op() function. BUT I CANN'T see any changes on DBGrid after
that. OK. I have another button called Refresh, which simply invokes Op()
function. Sometimes I have to click it twice or even more times before I'll
see changes in DBGrid.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads