[Dhis2-devs] help me on how to use replaceid syntax

2011-09-12 Thread Muhire Andrew
Thanks for the quick help, i have successfully used the select and delete steps(in datavalues and datavalue_audit) but using replace id is not working on my side may be am not using it well? please update me again (only replace syntax). i have deleted data from my data element x and next step

Re: [Dhis2-devs] help me on how to use replaceid syntax

2011-09-12 Thread Jason Pickering
Can you paste the exact query which you are using? On Mon, Sep 12, 2011 at 5:04 PM, Muhire Andrew muhireand...@yahoo.comwrote: Thanks for the quick help, i have successfully used the select and delete steps (in datavalues and datavalue_audit) but using replace id is not working on my side

Re: [Dhis2-devs] help me on how to use replaceid syntax

2011-09-12 Thread Knut Staring
Hi Andrew, There seems to be some confusion: You need to replace in the SQL statement before you run it. In order to find the right ID that should form part of the DELETE statement, you need to look at the dataelement table in your database, and e.g. run something like SELECT dataelementid FROM