On Monday 06 August 2018 19:16:53 mohamed hamza wrote:
> I think we can do more with recursive query like:
>
> with recursive CTE (nKey,caption ,nkeyp) AS (
> select id,name,pid FROM persons WHERE pid=:n
>union all
>select id,name,pid from persons
>join CTE t
>on t.nKey=
On Monday 06 August 2018 17:02:59 mohamed hamza wrote:
> You suggest to use tsqlresult but in this case we can not set primary
> key even less use find ( nkey, ) ?
>
There one uses the functions in the server with queries and SQL statements.
You suggest to use tsqlresult but in this case we can not set primary key
even less use find ( nkey, ) ?
Regards
Med
--
Check out the vibrant tech community on one of the world's most
engaging tech sites,
I think we can do more with recursive query like:
with recursive CTE (nKey,caption ,nkeyp) AS (
select id,name,pid FROM persons WHERE pid=:n
union all
select id,name,pid from persons
join CTE t
on t.nKey= persons.pid)
select * from cte ;
this sql statement is inserted to
4 matches
Mail list logo