How Can I Delete A Data Row In C++ (MFC)

Jun 21, 2004

Hi,

i like to delete data. I can read and write into the database. But somehow i cant delete data from my Microsoft SQL Server. Always get error on CanUpdate().

Did i forgto something ???


CODE::::
void CListAllDlg::OnBnClickedDelete()
{
CDatabase db;
CProducts m_pData(&db);
CString m_ListItem="";
int nItem=0;

POSITION pos = m_list_all.GetFirstSelectedItemPosition();

//open Recordset
if(m_pData.Open()==0)
{
AfxMessageBox("Datenbank Verbindung fehlgeschlagen", IDOK);
return;
}
if (MessageBox("Möchten Sie diesen Datensatz wirklich löschen?","Datensatz löschen", MB_YESNO | MB_ICONQUESTION) == IDYES)
{
do
{
m_ListItem = m_list_all.GetItemText(nItem,1);
//delete data
while(!m_pData.IsEOF())
{
//found data then delete
if(strcmp(m_pData.m_articel,m_ListItem)==0)
{

m_pData.Delete(); //delete data in database
m_pData.Update(); //confirm & update database
nItem = m_list_all.GetNextSelectedItem(pos);
m_list_all.DeleteItem(nItem); //delete data in listbox
MessageBox("Datensatz wurde erfolgreich gelöscht","Datensatz löschen", MB_OK);
}
m_pData.MoveNext();
}//end while
}while (pos != NULL);
m_pData.Close();
}//end if
}//end OnBnClickedDelete

View 8 Replies


ADVERTISEMENT

Master Data Services :: Hard Delete All Soft Delete Records (members) In Database

May 19, 2012

I am using Master Data Service for couple of months now. I can load, update, merge and soft delete data in MDS. Occasionally we even have to hard delete data from MDS. If we keep on soft deleting records in a MDS table eventually there will be huge number of soft deleted records. Is there an easy way to hard delete all the soft deleted records from all MDS tables in a specific Model.

View 18 Replies View Related

Delete Rows With Duplicate Column Data But Unique Row Data

May 25, 2000

Hello,

This probably has been addressed before but I was unable to get the search to work properly on this site.
I am needing a script/way of deleting all rows from a DB with the exception of one record left for each row that has duplicate column data. Example :
Row 1
Field1 = 12345 Field2 =xxxxx Field 3=yyyyy Field4=zzzzz etc.
Row 2
Field1 = 12345 Field2 =zzzzzz Field 3=xxxxxx Field4=yyyyyy etc.
Row3
Field1 = 12345 Field2 =20202 Field 3=11111 Field4=zzzzz etc.
Row 4
Field1 = 54321 Field2 =xxxxx Field 3=yyyyy Field4=zzzzz etc.
Etc. Etc.

I want to be able to find the duplicates for Field1 and then delete all but 1 of those rows.( I don't care which one I keep just so only one is left.) The data in the other fields may or may not be unique.

I know how to find the duplicates it's just the deleting part I am having problems with. Any help would be much appreciated. Thanks,

Kerry

View 3 Replies View Related

Integration Services :: Purge Data In Transaction Table Or Delete Some Data And Store In Separate Table

Aug 18, 2015

How to purge data  in transaction table or we can delete some data and store in separate table in data warehouse?

View 7 Replies View Related

Delete Data

Jun 28, 2007

Hello I have a little problem with deleting data from database. I have to tables
Category:
CategoryID,CategoryName,CategoryImageID - collumns
CategoryImage - table
CategoryImageID,CategoryImage - collumns
I have foreign key between Category.CategoryImageID and CategoryImage.CategoryImageID
How can I delete category from Category table.

View 8 Replies View Related

Delete Data

Jan 12, 2004

Hi,

I have two tables.

CREATE TABLE [one] (
[roleno] [int] NOT NULL ,
[schno] [int] NULL ,
CONSTRAINT [PK_one] PRIMARY KEY CLUSTERED
(
[roleno]
) ON [PRIMARY] ,
CONSTRAINT [FK_one_two] FOREIGN KEY
(
[schno]
) REFERENCES [two] (
[schno]
)
) ON [PRIMARY]
GO

CREATE TABLE [two] (
[roleno] [int] NULL ,
[schno] [int] NOT NULL ,
CONSTRAINT [PK_two] PRIMARY KEY CLUSTERED
(
[schno]
) ON [PRIMARY] ,
CONSTRAINT [FK_two_one] FOREIGN KEY
(
[roleno]
) REFERENCES [one] (
[roleno]
)
) ON [PRIMARY]
GO


(I fact i created Primary & Foreign keys after inserting data in both of these tables.)

I want to delete data from these two tables.
How do i do that...Any Ideas?

View 3 Replies View Related

How To Delete All The Data?

Apr 21, 2008

Hi,

I want to delete all the data in all tables.

But I have question for this.

1. I do not know how to loop over all the tables and delete data.
2. the database have database diagram so there are dependency with tables so the delete order is hard to decide.

a solutions is:

I temporarily delete the diagram and I loop all the tables and delete all the data.My question is how to loop over all the tables?

Please give me a idea.

Thanks

Mark

View 6 Replies View Related

Delete Row When Data Is Numeric?

Jan 9, 2004

I'm using a DTS package to import a large CSV file. There is a particular column that contains text or numbers. I want to delete the row if that column has a number, I've used IsNumeric in the selection portion of the statement, but can't figure out how to use it as part of my where clause.

View 1 Replies View Related

SQL Delete Table Data

Aug 8, 2000

How can I erase all data from every table in a SQL Server 7.0 database and leave all constraints and relationships in tact? I'm wanting to have just the structure or frame work with no data in any table. There are over 130 tables so I need to automate this. Any Suggestions?

View 3 Replies View Related

Delete All Data Which Are More Than One Week Old

May 9, 2004

Hi there,

How to delete all the data which are more than week old in the SQL Server?

Thanx

View 6 Replies View Related

How To Delete Data From All The Tables?

Apr 7, 2008

I want to reset my application and delete all the data in all tables.

But I have question for this.

1. I do not know how to loop over all the tables and delete data.
2. the database have database diagram so threre are dependency with tables so the delete order is hard to decide.

Please give me a idea.

Thanks

Mark

View 4 Replies View Related

Large Data Delete

Jul 20, 2005

HiI have a SQL2000 server with 128m rows of data. I want to delete about65m of that. So far I have bcp'ed the relevent data out and put theminto another SQL database.We have a small amount of space for our transaction log so I cannotdelete all 65m rows in one go. So far I have been doing them is 0.5mchuncks, but it is extremly slow.Would a faster way be to bcp the data I wan to keep and truncate thetable and bulk import them in again ?What hapnes to log size in when builk import is happening and is thereanother way of doing this ?Thanks for any help

View 2 Replies View Related

Delete All Data From An Sql Table Using Asp.net 2.0 Vb.net 2005

Nov 6, 2007

hi how to empty a table (delete all the data in it) using sql commands in asp.net 2.o and vb.net 2005please help .thanks  

View 3 Replies View Related

SQL Data Source Delete Statement

Feb 3, 2008

Hey everyone,
Currently I have a problem that with a gridview delete command because the database I currently want to delete from is a PK to 1 other table.  So how can I delete from that "Membership" table before I use the gridview to delete from the "Events" table?  Here is a very shortened version of the tables
Events
EventID (PK)
Membership
MembershipID
EventID (FK)
UserID (FK)
I have to delete ALL the members from the event in the membership table first before I can delete the actual Event...So how can I do that when the gridview only allows you to delete from 1 table, if I understand this correctly.
 Here is the sqldatasource delete command as of right now.
DeleteCommand="DELETE FROM [Events_Events] WHERE [EventID] = @original_EventID"
Obviously I am getting a error because of the FK.
Thanks,
Chris

View 2 Replies View Related

Delete Data Which Is A Primary And Foreign Key

May 26, 2008

Hi,
How do I delete data which is a Foreign Key in another table?
For example;
string query = "DELETE * from user_details WHERE user_ID = '" +userID.Text+ "';
The user_ID is the Primary Key in the user_details table and also a Foreign Key in other tables.
Thank you. (:

View 4 Replies View Related

Delete Data From GridView And ObjectDataSource

Mar 11, 2006

The function that is supposed to delete a row, is not working. The function is called, and the windows is refreshed, but the row is not deleted.Can anyone see anything wrong with this code:public static void DeleteBlog(int original_BlogID) { string insertCommand = "DELETE FROM Blog WHERE BlogID = @BlogID"; SqlConnection myConnection = new SqlConnection(Blog.ConnectionString); SqlCommand command = new SqlCommand(insertCommand, myConnection); command.Parameters.Add(new SqlParameter("@BlogID", original_BlogID)); myConnection.Open(); command.ExecuteNonQuery(); myConnection.Close();}

View 3 Replies View Related

Delete Data Without Impacting Tempdb

Aug 27, 2007

This is a SQL 2005 production server.

I have to delete around 51 million rows from a table which has 149 million rows.

Can't use truncate option as the other rows in the table are still needed.

How can I delete the rows without filling up the tempdb ?

If the tempdb fills up I can't bounce the server.

View 11 Replies View Related

Delete Data Before Trigger Executes

Jan 12, 2004

I am trying to delete data from a table prior to populating with new data via a trigger if certain critria matches to eliminate duplicates. I have copied the trigger below. The syntax checks ok but I get any error message saying 'Incorrect syntax near 'GO'. 'ALTER TRIGGER' must be the first statement in a query batch' when I try to save.

Can someone tell me if this is possible please.

IF EXISTS (SELECT * FROM hold_complete
WHERE fkey = hold_complete.fkey AND actiontext = 'hold' and Subactiontext = 'pending user')
delete from hold_complete where hold_complete.fkey = fkey
GO
CREATE TRIGGER tr_hold_complete ON CallsHistory
for INSERT AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
insert hold_complete
select ins.AddedDT, ins.fkey, ins.actiontext,
ins.subactiontext, con.emailaddress, ca.loggeddt,
(con.forename + ' ' + con.surname) as contactname,
ca.summary, ca.notes,co.coordinator, co.coordinator,getdate(), ca.status,ca.lastsubaction,getdate(),ca.dateopened ,ca.companyname,getdate(),(null),ch.notes
FROM inserted as ins with (nolock)
join calls as ca with (nolock)on
ins.fkey = ca.callid
join contact as con with (nolock) on
ca.contactid = con.contactid
join company as co with (nolock) on
ca.companyid = co.companyid
join callshistory as ch with (nolock) on
ins.historyid = ch.historyid
where ins.actiontext = 'hold' and ins.Subactiontext in ('completed','pending user')

View 9 Replies View Related

Stored Procedure To Delete Data Which Is 2 Yrs Old

Sep 24, 2007

Table Strucure - :
TestEven(TestNo,EmpNo,TestDate)


I jst want to write a stored procedure to delete all data which is 2 years old. thank you in adavance.
Hussain

View 3 Replies View Related

Statement To Delete All Dependencies Data.

Feb 6, 2008

Is there a SQL statement that will delete the primary key data and data in the other tables that depend on that primary key?

View 3 Replies View Related

Bulk Delete On Operational Data

Nov 23, 2005

Hello,I read several articles of newsgroup about the bulk delete, and I foundone way is to:-create a temporary table with all constraints of original table-insert rows to be retained into that temp table-drop constraints on original table-drop the original table-rename the temporary tableMy purge is a daily job, and my question is how this work on a heavyload operational database? I mean thousand of records are written intomy tables (the same table that I want to purge some rows from) everysecond. While I am doing the copy to temp table and drop the table whathappens to those operational data?I also realized another way of doing the bulk delete is using BCP:1) BCP out rows to be deleted to an archive file2) BCP out rows to be retained3) Drop indexes and truncate table4) BCP in rows to be retained5) Create indexesAgain the same question: When I'm doing the BCP is there any insertionblocking to my original table? What happens to my rows meantime to beinserted?Does BCP acquire an exclusive lock on the table which prevents anyother insertion?Does any one have an experience with a BCP command for querying out 2million records, and how long will it take?I appreciate your help.

View 2 Replies View Related

When I Delete Data, The Database Gets Larger?

Jan 8, 2008



I have written code to combine, delete redundant data in my system. The table structure remains the same, except I changed some INTs to TINYINTs.

When I do sp_spaceused, it tells me that number of rows is smaller(which is correct), but the datasize, and index_size is significantly larger AFTER the deletions.

I tried using shrink, but that doesn't seem to change anything.

When I right-click the database, and choose PROPERTIES, it also confirms that the database got significantly larger.

I am confused about how deleting data and changing to TINYINTs could make my database bigger. What would cause this?




View 9 Replies View Related

Article - Delete All Data Property

Sep 14, 2005

Hi There

View 7 Replies View Related

Transactional Replication Delete Data

Feb 15, 2007

In SQL Server 2005 SP1 we have a Transactional Replication with only this property in the articles:

Action: Delete data...

Ant this property in the publication:

Don't send schema changes

We have in the foreign keys NOT FOR REPLICATION = NO (Exigir para replicacion = "Si" in Spanish).

We have one problem and one doubt:

The problem is that when the sincronization goes wrong the table in the suscriptor is empty !!!!!. It seems that goes wrong because the foreign keys. The question is = Is necessary that NOT FOR REPLICATION = YES in all the tables?, we don't want any check in the sincronization.

Why the destiny tables appears empty?. Is very dangerous.

Thanks.

View 2 Replies View Related

Delete Data In Excel Using Openrowset?

Feb 23, 2008

Hello,
I would like to delete all data from an excel sheet except the headers row.
Is there any way to do this using Openrowset with JET or something like that?
Thanks
Philippe

View 26 Replies View Related

How To Delete Duplicate Data From Field

Oct 22, 2007



my table structure is
id field1
1 i am from india
2 i am from usa
3 i am from delhi


So i want to remove common data from field1 , means after run the query table should be like

id field1
1 india
2 usa
3 delhi

thanks in advance
saumitra tamrakar

View 8 Replies View Related

How Can I Delete Data From Multiple Access Table???

Jul 26, 2007

i am using asp.net vb, i have 2 table show as below if i want to delete the forumid 1 row,then how would i delete the topic table who belong to the forumid 1.
how would 1 do it if i am using gridview
Forum table
Forumid   |   Forumname
    1         |      hi
    2         |      me
Topic table
Topicid    |   Forumid   |   Topicname 
   1         |        1         |        yo
   2         |        1         |        everyone
   3         |        1         |        google

View 1 Replies View Related

How To Find Who Delete / Truncate Data From Table

Sep 6, 2013

how to find who delete/Truncate the data from table ,because i don't have any trigger on the table.

View 5 Replies View Related

SQL Server 2014 :: Cursor To Delete Data?

Nov 5, 2013

i have to delete data from a table which is older than 2 weeks, how can i use a cursor to do it.

I will have to place the query in a SQL job and run that weekly once

View 9 Replies View Related

SQL Server 2012 :: How To Archive Data And Delete

Apr 22, 2015

I am using SQL 2012 SE. I have 2 databases say A and B with same structure and relationships. There are 65 tables in each database. A is already replicating data to database C for 35 tables. Now I need to move data from A to B which is greater than getdate()-1 everyday for all the tables and once the move is done I need to delete this data from A. And the same thing the next day and everyday. Since this is for 65 tables its challenging to identify the insert order. Once the insert order is identified the delete order will be the reverse of it.

Is there a tool or any SP that could generate the insert order script? The generate scripts data only is generating the entire data and these databases are almost 400GB. Some tables have 200Mil+ rows. So it takes forever.

View 1 Replies View Related

How To Update,delete,insert The Data Into Xml Colu

Oct 10, 2007

Hi all,

How to update a particular value in xml file which was loaded into sql server 2005 database
which is of xml-type

How to DELETE a particular value in xml file which was loaded into sql server 2005 database
which is of xml-type

how to INSERT a particular value in xml file which was loaded into sql server 2005 database
which is of xml-type

update XmlCatalog1 set Document1.modify('delete /X12_U1_837/X12_Q1_837/header/ISA//ISA_Authorization_Information_Qualifier') where id=2

----------
The error which i am getting is
XML Validation: Invalid content. Expected element(s):ISA_Authorization_Information_Qualifier where element 'ISA_Authorization_Information' was specified. Location: /*:X12_U1_837[1]/*:X12_Q1_837[1]/*:header[1]/*:ISA[1]/*:ISA_Authorization_Information[1]

View 1 Replies View Related

Delete Data, But File Size Increase

Jul 23, 2005

I encounter one weird problem, I have a database with around 7 GB ...when I delete a bunch of data from it, it suppose to reduce thedatabase file size, but weirdly, the file size increase to 8 GB.Wondering why. Is it suppose to be like that?Is it the architecture is designed to work like that?Is there any way for me to reduce the database file size?Thanks.Peter CCH

View 2 Replies View Related

How To Delete Data Older Than X Days, Without Considering Time

Nov 11, 2005

When running the following SQL statements, I get the same results.Though I need to count only -30 days. Both statements below alsoconsider the time of the day as well, which is not desiredDELETE FROM MNT_RWHERE MNT_R.TIMESTAMP < GETDATE()- 30DELETE FROM MNT_RWHERE MNT_R.TIMESTAMP < DATEADD(d, -30, GETDATE())Here is the format of the values in columnMNT_R.TIMESTAMP2005-08-09 06:06:44.5772005-08-09 06:06:46.8102005-08-09 06:06:49.060So, since data are inserted into the MNT_R table every few seconds, mydelete statement will delete different number of rows, according to thetime of the day it runs.Can you please post a SQL query that will not give me this headache?thanx a lot all

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved