Updating or Deleting Records

In order to Update/Delete, records user must specify an update key.

For the example provided below, the following SQL is executed

(Update key is CustomerId, OrderNo)

Add New Records

Select count(*)
from [DEMO].[dbo].[orders]
where CustomerId=? And OrderNo=?

If no records found then new records are added

Add New And Update Old Records

Select count(*)
from [DEMO].[dbo].[orders]
where CustomerId=? And OrderNo=?

If any records found they are updated

Update [DEMO].[dbo].[orders]
set orderdate=?,
amount=?
where customerid=? And OrderNo=?

If no records found then new records are added

Update Records

Update [DEMO].[dbo].[orders]
set OrderDate=?,
Amount=?
where CustomerId=? And OrderNo=?

Delete Records

Delete from [DEMO].[dbo].[orders]
Where CustomerId=? And OrderNo=?

It is also possible to manually edit Insert/Update/Delete/Count SQL Statements. Tick user-defined SQL than edit every SQL statement individually. To regenerate the SQL statements clear it and open it again