Re: CRecordset::Open postgresql procedure call don't work

2019-07-15 Thread Pavel Stehule
Hi Dne po 15. 7. 2019 13:40 uživatel jeanclaude marzin < jeanclaude.mar...@sfr.fr> napsal: > ‌Hi > I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure > to Postgresql one : > > CREATE PROCEDURE procacp () > LANGUAGE SQL > AS $$ > SELECT tabjdbexploit.jdbeid, tabjdbexploit.jd

Re: CRecordset::Open postgresql procedure call don't work

2019-07-15 Thread John McKown
On Mon, Jul 15, 2019 at 6:40 AM jeanclaude marzin wrote: > ‌Hi > I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure > to Postgresql one : > > CREATE PROCEDURE procacp () > LANGUAGE SQL > AS $$ > SELECT tabjdbexploit.jdbeid, tabjdbexploit.jdbeproc, > tabjdbexploit.jdbeda

CRecordset::Open postgresql procedure call don't work

2019-07-15 Thread jeanclaude marzin
‌Hi I migrate from MSSQL to postgresql 11. I translate MSSQL stored procedure to Postgresql one : CREATE PROCEDURE procacp () LANGUAGE SQL AS $$ SELECT tabjdbexploit.jdbeid, tabjdbexploit.jdbeproc,     tabjdbexploit.jdbedate, tabjdbexploit.jdbetypemsg,     tabjdbexploit.jdbeurg, tabjdbexploit.jdb