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.
INSERT INTO DB_EDIMain(DebtorID)
SELECT DB_Main.DebtorID
FROM DB_Main
WHERE DB_Main.DebtorID NOT IN (SELECT DebtorID FROM DB_EDIMain)
Riyaz wrote:Is there a way to delete that via Jiwa interface? , also at the same time to create it.
Return to Technical and or Programming
Users browsing this forum: No registered users and 6 guests