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
wishmaster
Posts: 8
Joined: Sat 26 Apr 2014 19:00

Passing Parameters Between SQL and SQLUpdate

Post by wishmaster » 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:

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
Devart Team
Posts: 1057
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

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.

Post Reply