Table CUSTOMER
ID AUTOINCREMENT
NAME VARCHAR(100)
SQL
Code: Select all
select * from customer
Code: Select all
BEGIN
CUSTOMERS.Customer_Mng
(
:Customer_Id, --p_Id IN OUT PARAMETER
:Customer_Name,
'I' -- p_TipAcc (I: Insert; U: Update; D: Delete)
);
END;
Code: Select all
BEGIN
CUSTOMERS.Customer_Mng
(
:Customer_Id, --p_Id IN OUT PARAMETER
:Customer_Name,
'U' -- p_TipAcc (I: Insert; U: Update; D: Delete)
);
END;
Code: Select all
BEGIN
CUSTOMERS.Customer_Mng
(
:Customer_Id, --p_Id IN OUT PARAMETER
:Customer_Name,
'D' -- p_TipAcc (I: Insert; U: Update; D: Delete)
);
END;
the ReturnParams property is true in TMyQuery
In InsertMode I try to use
call CUSTOMERS.Customer_Mng(:Customer_Id, :Customer_Name, 'I') but doesn`t work.
Thanks