Page 1 of 1

TZQuery - problem with Params

Posted: 30.10.2009, 13:26
by h.o.o.k
Hi all, i am from czech republic so promise me my english.



I have problem with ZQuery.

In Zquery.SQL have:

select * from :TAB

ParamsCheck i have active (true).

So and now i want set the parameter by command:

Query.ParamByName('TAB').AsString := 'myTable';
Query.Open;

Application throw mesage: "invalid table name".
Table name exist!

When i set Query.SQL as "select * from myTable" so application running.

Dou you have where is a problem somebody?


Pleas...

Petr

Posted: 30.10.2009, 14:37
by h.o.o.k
I know ...

I Can't use table name ori view name or atributte name as parameter :0(((

Posted: 01.11.2009, 23:05
by mdaems
Yes, but I suppose you already saw the promise made be Rodrigosd in this post : http://zeos.firmos.at/viewtopic.php?t=2558 . His solution would be helpfull for you.

Mark

Thank YOU

Posted: 02.11.2009, 08:22
by h.o.o.k
mdaems wrote:Yes, but I suppose you already saw the promise made be Rodrigosd in this post : http://zeos.firmos.at/viewtopic.php?t=2558 . His solution would be helpfull for you.

Mark
SUPER , thak you very much. :)