Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 22-09-2009
Member
 
Join Date: Oct 2008
Posts: 100
Unable to delete records from Two Joined table

I have Emp_table1 and Emp_table2, they joined to each other I can flush records from one table to another table, but when I try to delete the records it does not do so? How do i need to do to delete records.
Reply With Quote
  #2  
Old 22-09-2009
Member
 
Join Date: Jan 2009
Posts: 140
Re: Unable to delete records from Two Joined table

I recently researched if perhaps the database had some kind of lock or permission limits and I was able to turn on "autoshrink" in hopes to reduce the size, but I think I need to wait until the SQL server resets or something. You may try using the following code <input name="delete" type="Submit" value="Delete " onClick="if (!confirm(\'This cannot be undone!\')) return false">

Just swap your submit button line for that
Reply With Quote
  #3  
Old 22-09-2009
Member
 
Join Date: Oct 2008
Posts: 180
Re: Unable to delete records from Two Joined table

I would suggest that you may want to stop the Service Desk Service On the application server, clear the cache and start the service again. go to Query Analyzer, and set rowcount 1 delete from mytable .. where key1=..., key2=.. , key3=..this will get rid of one row only.
Reply With Quote
  #4  
Old 22-09-2009
Member
 
Join Date: Oct 2008
Posts: 107
Re: Unable to delete records from Two Joined table

If you create the views through the the Views \ Customize or Views \ Define Views options in the client, the views are stored locally on your machine. Some front end tools (possibly including Enterprise Manager) cannot modify data in a table without a primary key, because they cannot know which row(s) they are affecting. If you created the views in the admin panel, the views would be stored in the database.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to delete records from Two Joined table"
Thread Thread Starter Forum Replies Last Post
PHP - I want to retrieve records from specific field from a MySQL table and build array using PHP bond007dev Software Development 3 19-07-2010 04:23 PM
SQL Query For Copy records from one table to another Bellamy Software Development 4 23-05-2010 12:36 AM
PHP mysql select unique records from one table Captain Carrot Software Development 6 13-05-2010 12:18 PM
Select unique records from a table Conraad Software Development 5 13-05-2010 12:01 AM
How to specify the table containing the records you want to delete Fragman Software Development 3 08-08-2009 11:57 AM


All times are GMT +5.5. The time now is 02:47 AM.