TZQuery - problem with Params

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
h.o.o.k
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 30.10.2009, 13:18

TZQuery - problem with Params

Post 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
h.o.o.k
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 30.10.2009, 13:18

Post by h.o.o.k »

I know ...

I Can't use table name ori view name or atributte name as parameter :0(((
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post 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
Image
h.o.o.k
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 30.10.2009, 13:18

Thank YOU

Post 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. :)
Post Reply