Can you paste the exact query which you are using?
On Mon, Sep 12, 2011 at 5:04 PM, Muhire Andrew <muhireand...@yahoo.com>wrote: > 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! and if i check my data in data entry form i find no data and if i > delete the data element in an interface next time i get error message for > the unreplaced id when i open the form. > waiting for your help dear team! > > > > > > ------------------------------ > > > *Muhire Andrew > * > *HMIS/Ministry of Health* > *andrew.muh...@moh.gov.rw* > *God is my provider.* > > > ------------------------------ > *From:* Jason Pickering <jason.p.picker...@gmail.com> > *To:* Muhire Andrew <muhireand...@yahoo.com> > *Cc:* Knut Staring <knu...@gmail.com>; Lars Helge Øverland < > larshe...@gmail.com>; "dhis2-us...@lists.launchpad.net" < > dhis2-us...@lists.launchpad.net>; "dhis2-devs@lists.launchpad.net" < > dhis2-devs@lists.launchpad.net> > *Sent:* Monday, September 12, 2011 4:13 PM > *Subject:* Re: [Dhis2-devs] Dear Dhis2 users how can i delete? > > It is best practice in all cases to ensure to you make a backup of your > database. Even with SELECT and DELETE, you may unknowingly make a typing > mistake. Anytime you start messing around with the database directly, ensure > you first make a backup, so that you can easily restore the database in case > you mess up something unintentionally. > > Another trick is to use a "SELECT INTO " statement, to put all of the data > you are about to delete into a separate table, and then perform the delete > operation. This way, it is relatively easy to see what you have deleted and > restore it once again, without reverting to a complete backup restore. > > Regards, > Jason > > > 2011/9/12 Muhire Andrew <muhireand...@yahoo.com> > > Thank you all, > Great Knut its rilly good to select first and then delete because it can > cause problems in case i delete the needed data. > > > > > ------------------------------ > > > *Muhire Andrew > * > *HMIS/Ministry of Health* > *andrew.muh...@moh.gov.rw* > *God is my provider.* > > > ------------------------------ > *From:* Knut Staring <knu...@gmail.com> > *To:* Lars Helge Øverland <larshe...@gmail.com> > *Cc:* Muhire Andrew <muhireand...@yahoo.com>; > dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net > *Sent:* Monday, September 12, 2011 3:56 PM > *Subject:* Re: [Dhis2-devs] Dear Dhis2 users how can i delete? > > As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so > that you are 100% sure you are not deleting data you really need. > > In this case: > > select * from datavalue_audit where dataelementid=<id>; > select * from datavalue where dataelementid=<id>; > > Knut > > 2011/9/12 Lars Helge Øverland <larshe...@gmail.com> > > 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-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > -- > Knut Staring > Informatics, U. of Oslo > http://hisp.uio.no > +4791880522 > > > > > _______________________________________________ > 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 > > > > >
_______________________________________________ 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
