Hi, The only two commands you should run on your database are the two delete statements; delete from datavalue_audit where dataelementid=<id>; delete from datavalue where dataelementid=<id>;
"Replace" is not a command, just Lars telling you to change the <id> in the two commands above with the real IDs of your data elements. Seems all is fine then. You can now try deleting the data elements from the DHIS 2 user interface. Ola ------ ---------------------------------- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link<http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway> 2011/9/12 Muhire Andrew <muhireand...@yahoo.com> > 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 was to use replace but am getting syntax > error! > waiting for your help dear team! > > > > > ------------------------------ > > > *Muhire Andrew > * > *HMIS/Ministry of Health* > *andrew.muh...@moh.gov.rw* > *God is my provider.* > > > ------------------------------ > *From:* Lars Helge Øverland <larshe...@gmail.com> > *To:* Muhire Andrew <muhireand...@yahoo.com> > *Cc:* dhis2-devs@lists.launchpad.net; dhis2-us...@lists.launchpad.net > *Sent:* Monday, September 12, 2011 3:51 PM > *Subject:* Re: Dear Dhis2 users how can i delete? > > Hi Andrew, > > you need to remove the data with SQL in the database. Run: > > delete from datavalue_audit where dataelementid=<id>; > delete from datavalue where dataelementid=<id>; > > and replace <id> with the dataelementid of the one you want to remove. > > You can then go ahead and delete the data element in the user interface. > > > > Lars > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
