Passing Parameters Between SQL and SQLUpdate
Posted: Thu 05 Jun 2014 22:12
Hi,
I've a datasnap application which SQL and SQLUpdate property filled for one of the queries.
Example:
SQL:
SQLUpdate:
When I give parameter and open table from client application, everything is OK.
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.
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=:CustomerIDCode: Select all
EXEC dbo.SOMEPROCEDURE :CustomerID, :BalanceWhen 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.