Passing Parameters Between SQL and SQLUpdate

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 8
Joined: Sat 26 Apr 2014 19:00

Passing Parameters Between SQL and SQLUpdate

Post by wishmaster » Thu 05 Jun 2014 22:12

I've a datasnap application which SQL and SQLUpdate property filled for one of the queries.


Code: Select all

SELECT Balance FROM TABLE1 WHERE CustomerID=:CustomerID

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.

Devart Team
Posts: 1000
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Passing Parameters Between SQL and SQLUpdate

Post by azyk » Fri 06 Jun 2014 14:21


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

Post Reply