Flynet DataConnect supports making changes to your data using manual text mode.
Once in manual text mode, you can type your INSERT, UPDATE, DELETE or equivalent SQL statement. There are a number of ways you can define parameters.
Examples
UPDATE Account
SET Name = @Param_name
WHERE Account.AccountID = @Param_accountid
INSERT INTO Account (Name, TerritoryID)
VALUES (@Param_name, @Param_territoryid)
DELETE FROM Account
WHERE Account.AccountID = @Param_accountid
Limitations
Parameters are single values only, i.e. you cannot pass in an array of records for an INSERT statement. All parameters are non-optional, and a value must be provided.