Zeoslib Portal

thanks! it works now

YES!
I resolve trouble.
LIMIT just was NULL on form show
thank you very very much )

but! anyway! parser dont give any chance to activate Zquery if "LIMIT :param" inside SQL script. very strange

wtf!!! same shit! dont works =) really. dont understand why. I cant change Zquery in active mode. I can use param everywhere: In COALESCE operator, in WHERE clause... but why it not works in LIMIT? this shows when i try to change Zquery to active mode http://img859.imageshack.us/img859/2323/32973743...

may be I can make paging using another method? does somebody knows how make paging in DBgrid without limit?
but amount of columns in paging - variable param

I can't!!!
cuz I use stored Zquery table with lookup columns
of course I can always clean Zquery.SQL and then refill it. but its not good for me

KAYAALP wrote: SELECT @n ::= @n+1 AS rownum, thing, arms, legs FROM limbs

Its not working in delphi 7, mysql 5.1 and zeos 6.6.6
how to use it in delphi 7?

or set checkparam = false in property of component (TZReadOnlyQuery)

I can't do this. cuz I have another params in query also.

could somebody help?

thank you very much! it works, but only if put in uses this: 'SqlExpr, ZConnection, ZAbstractRODataset, ZAbstractDataset, ZAbstractTable, ZDataset'

Does anyone know how use param for limit clause in Zquery?
In example:

SELECT *
FROM production
LIMIT :l

Its not works. And I dont understand why.

Hi. Could somebody give me the answer of question: how correctly to use param (datatype: ftString) in SQL (Zquery component)? It works when I use param (ftString) in WHERE clause It works when I use param (ftInteger) in ORDER BY clause BUT! when I use param (ftString) in ORDER By clause its not work...