Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: using a stored procedure inside tfdupdatesql component


This question is answered. Helpful answers available: 1. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Sep 25, 2016 8:52 AM Last Post By: Salim Naufal
Salim Naufal

Posts: 3
Registered: 12/7/99
using a stored procedure inside tfdupdatesql component  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 24, 2016 1:16 PM
I have a simple delphi application that relies on Firebird.

I then use a TFDQuery component in conjunction with a TFDUpdateSQL one. I need to replace the Delete SQL statement with a call to a stored procedure.
Trying to run the application, after deleting a record, I get the following exception:

EFDException [FireDAC]... Delete command deleted [0] instead of [1] record.

How an I use a stored procedure inside a TFDUpdateSQL component to perform custom tasks?

Thanks
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: using a stored procedure inside tfdupdatesql component
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 25, 2016 8:22 AM   in response to: Salim Naufal in response to: Salim Naufal
Set FDQuery.UpdateOptions.CountUpdatedRecords to False.

--
With best regards,
Dmitry
Salim Naufal

Posts: 3
Registered: 12/7/99
Re: using a stored procedure inside tfdupdatesql component  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 25, 2016 8:52 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Set FDQuery.UpdateOptions.CountUpdatedRecords to False.

--
With best regards,
Dmitry

Works great. Thanks
Salim
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02