Re: What's the best way to open a recordset for insert only?
- From: Spencer <Spencer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 8 Apr 2008 09:08:01 -0700
OK, this helps a lot, although I suppose we'll have to trust SQL Server not
to evaluate 0=1 or 1=2 for every existing row in the table.
"Bob Barrows [MVP]" wrote:
Spencer wrote:.
So it was a failed experiment, and it looks like I'll have to use the
recordset. But I'm wondering if there's a way to open the recordset
so that I can call AddNew on it, but doesn't query the entire table
first.
Use a disconnected recordset opened using a sql query that includes
"WHERE 1=2"
rs.CursorLocation = adUseClient
m_rsname = "select <fields> from " & m_rsname & " WHERE 1=2"
rs.Open m_rsname, m_conn, , adLockBatchOptimistic, adCmdText
Set rs.ActiveConnection = Nothing
'add your records, then
Set rs.ActiveConnection = m_conn
rs.UpdateBatch
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
- Follow-Ups:
- Re: What's the best way to open a recordset for insert only?
- From: Bob Barrows [MVP]
- Re: What's the best way to open a recordset for insert only?
- References:
- What's the best way to open a recordset for insert only?
- From: Spencer
- Re: What's the best way to open a recordset for insert only?
- From: Bob Barrows [MVP]
- What's the best way to open a recordset for insert only?
- Prev by Date: Re: What's the best way to open a recordset for insert only?
- Next by Date: Re: What's the best way to open a recordset for insert only?
- Previous by thread: Re: What's the best way to open a recordset for insert only?
- Next by thread: Re: What's the best way to open a recordset for insert only?
- Index(es):
Relevant Pages
|
|
