I've a datasnap application which SQL and SQLUpdate property filled for one of the queries.
Example:
SQL:
Code: Select all
SELECT Balance FROM TABLE1 WHERE CustomerID=:CustomerID
Code: Select all
EXEC dbo.SOMEPROCEDURE :CustomerID, :Balance
When I update balance, I see that :CustomerID parameter does passed as NULL (probably never passed) to SQLUpdate AND I got "Cannot insert the value NULL into column..." errors.