1

Topic: Request with parameter access

Hello, in  used request with parameter for a date choice

ADOQuery1.Close;
AdoQuery1.Sql. Text: ='SELECT * FROM Klienty_izmenen WHERE of Data_redaktirovanie =:data1 ';
AdoQuery1.Parameters. ParamByName (' data1 ').Value: = DateOf (DBDateTimeEditEh1.Value);
ADOQuery1.Open;

But I need to rebuild that the request was in access and from there it to cause
At once wrote so

SELECT *
FROM Klienty_izmenen
WHERE Data_redaktirovanie =:data1;

And already in  it connected

SELECT * FROM Zapros1

but at activation ADOQuery writes that the parameter data1 has no value by default. Prompt as to make that worked

2

Re: Request with parameter access

elimpion wrote:

... But at activation ADOQuery writes that the parameter data1 has no value by default. Prompt as to make that worked

Well think. 1 in Access. And parameter data1 in the same place. But you   try to open this request. It is feeblly familiar with Access but if the Request is an analog  so to make it does not turn out. If requests are an analog of procedures it is necessary to transfer parameter in it.
Approximately so:

SELECT * FROM Zapros1 (:data1)

3

Re: Request with parameter access

Excuse can it is wrong you understood, changed request in ADOQuery on that that you wrote, the error "jumped out the object parameter" is incorrectly defined

4

Re: Request with parameter access

elimpion;
https://support.office.com/ru-ru/articl … b7cf9d9888

5

Re: Request with parameter access

[quote =] SELECT * FROM Zapros1 (:data1)

Not .
[quote =] but me it is necessary to rebuild that the request was in access and from there it to cause

And in what sense of creation of Zapros1 if it sql it is similar earlier used in... AdoQuery1.Sql. Text.?