Passing Parameters Between SQL and SQLUpdate

[wishmaster]

Hi,
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

SQLUpdate:

Code: Select all

EXEC dbo.SOMEPROCEDURE :CustomerID, :Balance

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.

[azyk]

Hi,

We couldn't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to andreyz*devart*com.