# could not delete record, try showAll records **URL:** \ **Category:** Classic Servoy\ **Created:** [February 17, 2004, 3:37pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289 "2004-02-17T15:37:12Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 17, 2004, 3:37pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/1 "2004-02-17T15:37:12Z")
Hello, I am getting this error now all the time. It looks like it might have to do with tracking. I am using the latest version on Windows XP. The error is this > java.lang.NullPointerException > at com.servoy.j2db.dataprocessing.SQLStatement.setTrackingData(Unknown S > ource) > at com.servoy.j2db.dataprocessing.q.a(Unknown Source) > at com.servoy.j2db.dataprocessing.FoundSet.deleteRecord(Unknown Source) > at com.servoy.j2db.FormPanel.d1(Unknown Source) > at com.servoy.j2db.FormPanel.access$3(Unknown Source) > at com.servoy.j2db.FormPanel$JSForm.js\_deleteRecord(Unknown Source) > at inv5.invoke() > at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:53 > 7) > at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:453) > at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1232) > at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1940) > at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.j > ava:94) > at com.servoy.j2db.scripting.e.call(Unknown Source) > at com.servoy.j2db.develop.c.i.executeFunction(Unknown Source) > at com.servoy.j2db.FormPanel.a(Unknown Source) > at com.servoy.j2db.FormPanel.actionPerformed(Unknown Source) > at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) > at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknow > n Source) > at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) > at javax.swing.DefaultButtonModel.setPressed(Unknown Source) > at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour > ce) > at java.awt.Component.processMouseEvent(Unknown Source) > at java.awt.Component.processEvent(Unknown Source) > at java.awt.Container.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Window.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.EventQueue.dispatchEvent(Unknown Source) > at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) > > at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.run(Unknown Source) > java.lang.NullPointerException > java.lang.NullPointerException > at com.servoy.j2db.dataprocessing.SQLStatement.setTrackingData(Unknown S > ource) > at com.servoy.j2db.dataprocessing.q.a(Unknown Source) > at com.servoy.j2db.dataprocessing.FoundSet.deleteRecord(Unknown Source) > at com.servoy.j2db.FormPanel.d1(Unknown Source) > at com.servoy.j2db.FormPanel.access$3(Unknown Source) > at com.servoy.j2db.FormPanel$JSForm.js\_deleteRecord(Unknown Source) > at inv5.invoke() > at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:53 > 7) > at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:453) > at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1232) > at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1940) > at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.j > ava:94) > at com.servoy.j2db.scripting.e.call(Unknown Source) > at com.servoy.j2db.develop.c.i.executeFunction(Unknown Source) > at com.servoy.j2db.FormPanel.a(Unknown Source) > at com.servoy.j2db.FormPanel.actionPerformed(Unknown Source) > at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) > at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknow > n Source) > at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) > at javax.swing.DefaultButtonModel.setPressed(Unknown Source) > at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour > ce) > at java.awt.Component.processMouseEvent(Unknown Source) > at java.awt.Component.processEvent(Unknown Source) > at java.awt.Container.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) > at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) > at java.awt.Container.dispatchEventImpl(Unknown Source) > at java.awt.Window.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.EventQueue.dispatchEvent(Unknown Source) > at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) > > at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.run(Unknown Source) Thanks for investigating! Patrick ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [February 17, 2004, 7:14pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/2 "2004-02-17T19:14:58Z")
Do you have a reproduceable testcase? ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 17, 2004, 8:34pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/3 "2004-02-17T20:34:18Z")
yes. I have that now all the time. I just didn’t notice, because I develop more than I enter data ![:lol:]( "Laughing") It looks like that I can’t delete at all. Nothing, nowhere. No matter what table. ![:?]( "Confused") ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [February 17, 2004, 8:52pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/4 "2004-02-17T20:52:02Z")
can you send it to me (solution and database?) ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 18, 2004, 7:48am UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/5 "2004-02-18T07:48:59Z")
that is a little difficult. I have to send you a few pretty big SQL Server databases… How do we do that? Is there any other way we can track this down? ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [February 18, 2004, 5:36pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/6 "2004-02-18T17:36:55Z")
Ok i could reproduce it! Fixed in the next release (2.0RC7) ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 18, 2004, 9:27pm UTC](https://forum.servoy.com/t/could-not-delete-record-try-showall-records/1289/7 "2004-02-18T21:27:41Z")
I am glad ![:lol:]( "Laughing")