Форум: "Базы";
Текущий архив: 2002.04.18;
Скачать: [xml.tar.bz2];
ВнизПередача параметров для Select в хранимую процедуру Найти похожие ветки
← →
OlegE (2002-03-26 16:21) [3]FIBPlus - это позволяют!
While working with TpFIBDataSet and TpFIBQuery it is also possible to use in the query macroses of the following types:
@MACROS_NAME[%][#]
@ - a sign of the beginning of the macros
% - an optional beginning of the default value of the macros
# - an optional sign that it it necessary to write the value of the macros
in inverted commas.
Using macroses you can dynamically change names of tables and fields in a query, conditions, etc.
To get access to values of macroses use ParamByName. ParamNameCount helps to get the total number of macroses in a query.
The example of using of macroses:
select * from @TT%TABLE1 where @F%FIELD1=@VAL%#John
The default form of the query before sending off to the server is
select * from TABLE1 where FIELD1="John"
Страницы: 1 вся ветка
Форум: "Базы";
Текущий архив: 2002.04.18;
Скачать: [xml.tar.bz2];
Память: 0.43 MB
Время: 0.006 c