Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 delete records from a databse

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-09 : 07:12:51
jacco writes "I'd like to delete a record from a database and i like to do this with a statement that's the same or all most the same as the statement to add an record to a database. I use the statement Users.AddNew to add an record and i like to known if there is an statement like Users.Delete or Usere.Remove."

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2003-01-09 : 07:16:57
Please be more specific...

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-01-09 : 07:20:32
I think he might be talking about the .AddNew method in ADO.

Damian
Go to Top of Page

JozzaTheWick
Starting Member

16 Posts

Posted - 2003-01-30 : 14:49:59
You can use the 'Delete' method.

e.g.

dim oRs as RecordSet

'open recordset
ors.open sMyConnString
'move to the last record
ors.movelast
'delete it
ors.delete
'add another
ors.addnew "New UserName"


Go to Top of Page
   

- Advertisement -