Jump to content

  •  

Photo

Deleting records via ESS not working


  • Please log in to reply
1 reply to this topic

#1 Reed  Pooh-Bah

Reed
  • Members
  • 1,537 posts
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 1h 49m 23s

Posted 14 February 2012 - 10:52 PM

I've set up ESS with a SQL server 2008 database, and viewing/editing records seems to be working fine. The problem I've encountered is that when I try to delete a record via ESS, it appears to delete, but when I search for the record again it is still there (and it's there if I look for it in SQL server management studio) I get no error messages when deleting, and if I run a delete query in the SQL server management studio, the record really does delete in that case.

Has anyone encountered an issue like this where ESS does not allow deletion?
  • 0

#2 Reed  Pooh-Bah

Reed
  • Members
  • 1,537 posts
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 1d 1h 49m 23s

Posted 16 April 2012 - 12:39 PM

So a partial answer to my own question is that the data which I couldn't delete is being audited in SQL server. There are other tables which are not audited in which I'm able to delete records just fine. I just can't delete records in audited tables via ODBC or ESS. Still not sure why that is though.
  • 0




FMForum Advertisers