On Thursday 29 September 2016 18:44:48 mohamed hamza wrote:
> Hi Martin,
>
> I agree that using tsqlstringlist is the best solution. I used
> sql.macros[i] but I did not find how to use itembyname?
"
macroquery.active:= false;
macroquery.sql.macros.count:= 2;
macroquery.sql.macros[0].name:= 'fields';
macroquery.sql.macros[1].name:= 'table';
macroquery.sql.text:= 'select ${fields} from ${table}';
macroquery.sql.macros.itembyname('fields').value.text:= 'ID,TEXT1';
macroquery.sql.macros.itembyname('table').value.text:= 'TABLE1';
{ or faster:
macroquery.sql.macros[0].value.text:= 'ID,TEXT1';
macroquery.sql.macros[1].value.text:= 'TABLE1';
}
macroquery.active:= true;
"
Macroitems value property is of type tmacrostringlist. It is possible to
construct complex nested statemens or to use the same complex macro in
different positions of the SQL statement.
Martin
------------------------------------------------------------------------------
_______________________________________________
mseide-msegui-talk mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
