DB_EDIMain table

Discussions relating to plugin development, and the Jiwa API.

DB_EDIMain table

Postby Riyaz » Thu Mar 19, 2020 6:02 pm

Hi There

How do we manage the data in the table DB_EDIMain , a record from it got vanished and am wondering how did that happen, and now trying to put it back. Pls advice.
Riyaz
Kohai
Kohai
 
Posts: 233
Joined: Wed Dec 02, 2015 2:05 pm
Topics Solved: 2

Re: DB_EDIMain table

Postby Mike.Sheen » Thu Mar 19, 2020 10:30 pm

Riyaz wrote:Hi There

How do we manage the data in the table DB_EDIMain , a record from it got vanished and am wondering how did that happen, and now trying to put it back. Pls advice.


You can create records into the DB_EDIMain where there are none for existing debtors with the following query:

Code: Select all
INSERT INTO DB_EDIMain(DebtorID)
SELECT DB_Main.DebtorID
FROM DB_Main
WHERE DB_Main.DebtorID NOT IN (SELECT DebtorID FROM DB_EDIMain)


How did those records vanish?
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: DB_EDIMain table

Postby Riyaz » Thu Mar 19, 2020 10:39 pm

Thanks Mike

Not sure about how did it vanish, am still investigating that.

Is there a way to delete that via Jiwa interface? , also at the same time to create it. I can use the query no problems, just wanted to know.
Riyaz
Kohai
Kohai
 
Posts: 233
Joined: Wed Dec 02, 2015 2:05 pm
Topics Solved: 2

Re: DB_EDIMain table

Postby Mike.Sheen » Fri Mar 20, 2020 9:06 am

Riyaz wrote:Is there a way to delete that via Jiwa interface? , also at the same time to create it.


When you create a new debtor, a record is inserted into DB_EDIMain for you. When a debtor is deleted, that record is removed for you.

There is no way via the user interface (or even the business logic) to delete rows from DB_EDIMain without deleting the corresponding row from DB_Main also.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 9 guests

cron