Enterprise manger

[Tom Wright]

How come when I want to reset a date field to NULL my Enterprise manger locks up and I have to kill it? This is after I have right clicked on a table and choose return all rows. Then I click on the date/time field and delete what was in there. Is there another way to do this besides running a SQL statement? Thanks Tom Wright tawright915@yahoo.com

[David Salter]

I've never seen it do that before. Is it a big table? Does it have the relevant indexes on it?

---

Database FAQ

[Tom Wright]

small table. with only three records. We use it as a heartbeat table so that other apps know that my app is still working. Davey wrote: Does it have the relevant indexes on it? Yeah. It's strange. I might see if there is a SP for it. Tom Wright tawright915@yahoo.com

[tojamismis]

Have you tried Running a Query from enterprise manager on the table? You can get only the row or rows you need and then update from the results pane in the Query builder. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

[Tom Wright]

yeah. If I do an update on that field, passing NULLS, it works fine. I just cannot click in that field, delete what's in there and click out of it. if I do it freezes up. Tom Wright tawright915@yahoo.com

[WoutL]

Pressing Delete in Enterprise Manager is not the same as resetting to NULL. Delete will update the field with '' (Empty string) If you want to update the field to NULL in Enterprise Manager press Ctrl-0 Wout Louwers