Zayyad - You seem to be trying to accomplish something that is not anticipated in the application.
As you know from being part of this mifos/fineract community for (I think) a decade, that it would be better to have you report this as a feature request or repeatable issue with sufficient information to be of use to the broader community. It is best if we all use some common approaches to reporting issues and getting input. By jumping to a low level database restriction approach, this is skipping several important steps of understanding the intent and the approach. *Rows in a database table are, by definition, why you have a database table.* Write restrictions are normal and probably should be enforced at a different level. Step by step guide for getting help is here>> https://cwiki.apache.org/confluence/display/FINERACT/Getting+Help+with+Issue Perhaps you can explain more? Thanks, On Mon, Feb 15, 2021 at 7:48 AM V G <[email protected]> wrote: > Hello *Zayyad,* > > *I think the only difference between the database with multi row and > single row will be the id column. So if this column is removed the the data > table need to be converted to single row. Please proceed with caution and > take a back up of the table before changes.* > > *Regards* > *Venkata* > > > On Mon, 15 Feb, 2021, 8:09 pm , <[email protected]> wrote: > >> Hi Francis, >> >> >> >> I don’t understand how truncating will solve our issue. >> >> >> >> We want to change the data table from accepting multiple rows, we have >> already deleted the excess records that were created. >> >> >> >> Any idea on how we can achieve this? >> >> >> >> Regards; >> >> ********* >> >> *Zayyad A. Said | Chairman & C.E.O* >> >> Cell No.: +254 716 615274 | Skype: *zsaid2011* >> >> Email: [email protected] >> >> Schedule Meetings: https://calendly.com/zayyadsaid >> >> >> >> *From:* Francis Guchie <[email protected]> >> *Sent:* Sunday, February 14, 2021 11:50 PM >> *To:* Mifos software development <[email protected]> >> *Cc:* Dev <[email protected]> >> *Subject:* Re: [Mifos-developer] Multi to Single Row Datatable >> >> >> >> Dear Zayad, >> >> >> >> My view is you will have to truncate the data >> >> >> >> >> >> My Kind Regards >> >> >> >> Francis Guchie Kirago >> >> *Skype:* francisguchie >> >> *Telegram: *232 79 19 44 07 >> >> *Whatsapp: *232 79 19 44 07 >> >> *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >> >> twitter: @FrancisGuchie >> >> >> >> >> >> >> >> >> >> >> >> >> >> On Sat, Feb 13, 2021 at 11:54 PM <[email protected]> >> wrote: >> >> Hello Devs, >> >> >> >> We have a request to amend a data table already with data from multi-row >> to single row. >> >> >> >> We don’t seem to see how this is possible, if there is anyone who has >> successfully changed a datatable before please share steps to go about it. >> >> >> >> Will appreciate quick feedback. >> >> >> >> Regards; >> >> ********* >> >> *Zayyad A. Said | Chairman & C.E.O* >> >> Cell No.: +254 716 615274 | Skype: *zsaid2011* >> >> Email: [email protected] >> >> Schedule Meetings: https://calendly.com/zayyadsaid >> >> >> >> Mifos-developer mailing list >> [email protected] >> Unsubscribe or change settings at: >> https://lists.sourceforge.net/lists/listinfo/mifos-developer >> >>
