David Kroll
-
Content Count
2 -
Joined
-
Last visited
Posts posted by David Kroll
-
-
:EDIT - Nevermind, there was code replacing the parameter with the value that I missed previously.
Hello all,
I am converting an application from Delphi XE5 to Delphi 11.1. I have a TFDQuery with 2 parameters, below is the where clause of the query.
WHERE ATTRIB_51 = :PWD and EMAIL_ADDR = :USEREMAIL
When stepping through the code, when I try to set ParamByName, it throws an exception with message Inaccessible value. I tried changing from parameters to macros by changing : to ! in the query and using MacroByName, but it throws the same exception. Any ideas?
fdqUser.ParamByName('PWD').Value := UserPwd;
fdqUser.ParamByName('USEREMAIL').Value := UserEmail;
FireDac ParamByName Exception
in Databases
Posted
There was code that was replacing the parameters with the actual values, making the parameters no longer there. I figured it out finally. Thanks for your time!