From: cbaskara@yahoo.co.in (baskar)
Subject: Table read before inserting a record using Recordset update
Date: 14 Aug 2003 06:57:57 -0700
Date: 2003-08-14T13:57:58+00:00 [thread overview]
Message-ID: <b5a71bcf.0308140557.209545e@posting.google.com> (raw)
Hi,
Trying to insert a record using the records section option
(rs.addNew()). I think it reads the whole table. I'm using the query
"select * from table where primary key = 1" for opening the record
set. My DBA is reporting that she is seeing "select * from table"
query is issued very frequently (where as we never issue this query
from any where else).
I'm suspecting that addNew() function reads the whole table before
inserting the record, but not sure. Any ideas or suggestions?
Thanks !
Regards,
Baskar
next reply other threads:[~2003-08-14 13:57 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2003-08-14 13:57 baskar [this message]
2003-08-14 15:21 ` Table read before inserting a record using Recordset update Robert I. Eachus
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox