1

Topic: How to disconnect check of parameters in request?

I use component TUniQuery;
At substitution of parameter X.ParamByName (' ID ').AsInteger: = 2;
The output the message "parameter ID is not found"
I know that it in the absence of request. The request will be substituted then.
Whether it is possible how to interpose the data without request?

2

Re: How to disconnect check of parameters in request?

Whether

gera3323 wrote:

It is possible how to interpose the data without request?

It is impossible.

3

Re: How to disconnect check of parameters in request?

Dimitry Sibiryakov wrote:

It is impossible.

And if to do here how then storage to release?

Uni:: TUniParam* __ fastcall TTypedBase:: ParamByName (const System:: UnicodeString Field)
{
Uni:: TUniParam* FUniParam = new Uni:: TUniParam (0);
FUniParam-> Name = Field;
FUniQuery-> Params-> AddParam (FUniParam);
return FUniParam;
}

4

Re: How to disconnect check of parameters in request?

gera3323;
Easier CheckParams in true to expose. What for to you parameters without request? Type - "I will set parameter"X", and in request comes"Y"?

5

Re: How to disconnect check of parameters in request?

DarkMaster;
The method for storage of parameters can advise?

TypedChoice = new TTypedChoice (this, _db-> ora);
TypedChoice-> setSQLChoiceQuery ("select ID AS RETURN, DBA_USER_NAME AS DISPLAY from RM_USERS ID =:ID");
TypedChoice-> ParamByName ("ID")-> AsAnsiString = "root";
//the method saves request for its usage later
setSQLChoiceQuery
//the method loads the data
TypedChoice-> Query ();

6

Re: How to disconnect check of parameters in request?

gera3323;
Base class about the such

class TSQLQuerySet
{
protected:
/* */
System:: UnicodeString FSQLChoiceQuery;
/* Request by default */
System:: UnicodeString FSQLDefaultQuery;
/* Request  to performance */
System:: UnicodeString FSQLCurrentQuery;
/* Request for an insertion */
System:: UnicodeString FSQLInsertQuery;
/* Request for update */
System:: UnicodeString FSQLUpdateQuery;
/* Request for removal */
System:: UnicodeString FSQLDeleteQuery;
/* Request for check of existence of record in the table before its insertion */
System:: UnicodeString FSQLBeforeInsertQuery;
/* Request for check of existence of record in the table before its update */
System:: UnicodeString FSQLBeforeUpdateQuery;
/* Request for check of existence of record in the table before its removal */
System:: UnicodeString FSQLBeforeDeleteQuery;
/* Request for search */
System:: UnicodeString FSQLSearchQuery;
/* a primary key Name */
System:: UnicodeString FPKName;
/* Values of primary key */
System:: UnicodeString FPKValue;
}