|
 |
asp_databases thread: ---Delete records from recordset
Message #1 by "Frangipane, Brian J." <BRIAN.J.FRANGIPANE@s...> on Thu, 28 Jun 2001 17:23:58 -0400
|
|
Could someone give me a quick code example of the recordset.Delete function
where the record is only deleted from the recordset and not the actual
database table. I need to remove certain records from a large set, however
I do not want them removed from the database permanently. I would
appreciate any help.
Thanks.
--Brian
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 29 Jun 2001 09:59:44 +1000
|
|
Disconnect the recordset?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Frangipane, Brian J." <BRIAN.J.FRANGIPANE@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, June 29, 2001 7:23 AM
Subject: [asp_databases] ---Delete records from recordset
: Could someone give me a quick code example of the recordset.Delete
function
: where the record is only deleted from the recordset and not the actual
: database table. I need to remove certain records from a large set,
however
: I do not want them removed from the database permanently. I would
: appreciate any help.
: Thanks.
:
: --Brian
:
Message #3 by "Frangipane, Brian J." <BRIAN.J.FRANGIPANE@s...> on Fri, 29 Jun 2001 13:23:06 -0400
|
|
How exactly would I do that? After removing the specific records from
the
record set I need to then use it for another operation.
Thanks,
Brian
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Thursday, June 28, 2001 8:00 PM
To: ASP Databases
Subject: [asp_databases] Re: ---Delete records from recordset
Disconnect the recordset?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Frangipane, Brian J." <BRIAN.J.FRANGIPANE@s...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, June 29, 2001 7:23 AM
Subject: [asp_databases] ---Delete records from recordset
: Could someone give me a quick code example of the recordset.Delete
function
: where the record is only deleted from the recordset and not the
actual
: database table. I need to remove certain records from a large set,
however
: I do not want them removed from the database permanently. I would
: appreciate any help.
: Thanks.
:
: --Brian
Message #4 by "Tomm Matthis" <matthis@b...> on Fri, 29 Jun 2001 17:01:28 -0400
|
|
You can make a copy of the recordset.
Write it out to a stream object, and then read that into a new rs
object.
YOu have the new one to cut up as you wish, and still have the original
for the next use.
-- Tomm
> -----Original Message-----
> From: Frangipane, Brian J. [mailto:BRIAN.J.FRANGIPANE@s...]
> Sent: Friday, June 29, 2001 1:23 PM
> To: ASP Databases
> Subject: [asp_databases] Re: ---Delete records from recordset
>
>
> How exactly would I do that? After removing the specific records from
the
> record set I need to then use it for another operation.
> Thanks,
> Brian
>
> -----Original Message-----
> From: Ken Schaefer [mailto:ken@a...]
> Sent: Thursday, June 28, 2001 8:00 PM
> To: ASP Databases
> Subject: [asp_databases] Re: ---Delete records from recordset
>
>
> Disconnect the recordset?
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: "Frangipane, Brian J." <BRIAN.J.FRANGIPANE@s...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, June 29, 2001 7:23 AM
> Subject: [asp_databases] ---Delete records from recordset
>
>
> : Could someone give me a quick code example of the recordset.Delete
> function
> : where the record is only deleted from the recordset and not the
actual
> : database table. I need to remove certain records from a large set,
> however
> : I do not want them removed from the database permanently. I would
> : appreciate any help.
> : Thanks.
> :
> : --Brian
>
|
|
|
View Cart
