Jiwa

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 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?

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 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.