CRUD SQL Result set problems
In connection with table.select() I have three questions and I haven't found anything after reading
https://dev.mysql.com/doc/x-devapi-userguide/en and searching the internet:
- How can I see and handle that a table.select has an empty result set? In the node.js xdevapi implementation I do not get the result set, only result rows one after another and my .execute(callback) is not even once called.
- Because my callback is called several times I do not know when it is called the last time i.e., when do I get the last row from the result set. How can I see and handle it?
- COUNT(*) / * is not accepted in the select string throwing an unexpected token error at the * character both cases. This is standard SQL, though. I can see that I can use session.sql('SELECT COUNT(*) FROM table') but I am curious to know why not in CRUD then?
Subject
Written By
Posted
CRUD SQL Result set problems
February 16, 2019 03:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.