Member Avatar for chiragvaghela
chiragvaghela 0 Newbie Poster 
res = PQexec(conn,"BEGIN");
PQClear(res);
res = PQexec(conn,"DECLARE myportal cursor for select * from test");
PQClear(res);
res= PQexec(conn,"FETCH ALL IN myportak");

----
---USE THE RESULT SET

-------

PQClear(res);
res = PQexec(conn,"END");
PQClear(res);
  • 1 Contributor
  • 0 Replies
  • 49 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.