Hi,
is there a way to turn off param checking for a query? Reason is many times PostgreSQL queries will have stuff like this in them:
select junk::text
The PGSQL way of casting uses : which is the same as what Delphi Params use. It would be nice to have a property called ParamCheck and if set to false it does no checking for params.
Query Params Question
When ParamCheck = False, the Params collection is not filled automatically. You should add parameters to Params manually.
But SQL statement is parsed anyway, and parameter names in the statement are replaced with $1, $2, etc.
Note 1: PgDAC does not treat ::name as a parameter. So don't worry about such type casts.
Note 2: The ParamCheck property works incorrecly in the beta version. We'll fix a bug with this this property in the next PgDAC build.
In the next build the ParamCheck property of TPgQuery will be published.
But SQL statement is parsed anyway, and parameter names in the statement are replaced with $1, $2, etc.
Note 1: PgDAC does not treat ::name as a parameter. So don't worry about such type casts.
Note 2: The ParamCheck property works incorrecly in the beta version. We'll fix a bug with this this property in the next PgDAC build.
In the next build the ParamCheck property of TPgQuery will be published.