Re: How to create a temporary Primary Index for an ADO recordset
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 13 Nov 2007 07:08:17 -0500
DPM wrote:
Hi,
My requirement is to base the updates issued from an ADO RecordSet,
on SQL server to use the Primary Key, rather than using all the
fields in the WHERE clause, for the UPDATE.
This can be done by setting the property in the RecordSet as follows,
RecordSet.Properties("Update Criteria").Value = 0
But is there any way without creating a Primary Key in the SQL DB to
issue the update for a given field ?
Not that I know of.
Or could this be achieved by creating a temporary Primary Key on theNo.
RecordSet ?
The only way to have total control over this is to write and execute your
own UPDATE statement.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- References:
- Prev by Date: Re: How can i get the "true" name of an aliased field?
- Next by Date: Re: Error => -2147467259 Could not save; currently locked by another
- Previous by thread: How to create a temporary Primary Index for an ADO recordset
- Next by thread: How can i get the "true" name of an aliased field?
- Index(es):
Relevant Pages
|
|
