This is the side effect of an imperfect separation of PIP from Profile (as noted, the engine is mature, but the separation of PIP from Profile is not). So, yes, WebSQL only supports SELECTs right now. But any 3rd party tool accessing PIP via the JDBC driver (e.g., DbVisualizer) should have a fully functional SQL editor.
Regards
-- Bhaskar
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Whenever I try to run something other than a SELECT statement in WebSQL, I get this response:
%SQL-E-FROM clause is required
Does this mean the WebSQL tool only supports SELECT?
Ed
Ed --
This is the side effect of an imperfect separation of PIP from Profile (as noted, the engine is mature, but the separation of PIP from Profile is not). So, yes, WebSQL only supports SELECTs right now. But any 3rd party tool accessing PIP via the JDBC driver (e.g., DbVisualizer) should have a fully functional SQL editor.
Regards
-- Bhaskar