Table of Contents
This part of the documentation will give some hints on how to use HyperSQL. Topics like Installation, Configuration, JavaDoc, Syntax Highlighting and Localization are dealt with in the other parts of the documentation.
First some background information, which should help you to better and easier understand the details following.
HyperSQL was originally developed by Randy Phillips back in 2001. After its release in the very same year, there have been no updates until I continued development in 2010 (take it binary, and it's just the next number), Randy handing me over all resources. He might have had different ideas of the final state of the programm, such using approaches which where perfect for those but might be a bit hindering now. Nevertheless, it would mean a complete rewrite to change them - so for now I chose to live with the possible limitations caused by those rather than spending long time to re-organize everything (time which I don't have).
One of these things is the linewise processing of code: HyperSQL does no complete SQL syntax analyzis. To find objects, it simply walks the code files line by line looking out for declarations such as e.g. CREATE TABLE xxx. Obviously all code Randy was concerned about was bundled in packages - so functions and procedures were only looked for if a package declaration was met. No stand-alone functions/procedures were expected. They are still not handled today (at version 3.4.5) - the special problems with those stand-alone objects are described in Object Order.
At another task, this linewise processing has already been replaced by a full file scan: Looking where objects are used. While switching to regular expression search for more accuracy considerably slowed down this process, switching from walking line-by-line to a full file scan fully compensated for the loss.
And before you ask (you might already have guessed that): The naming conventions for the generated HTML files of objects are bound to historic reasons as well. I know, this makes it almost impossible to have "steady links" to the page describing an object (and I don't like that idea either) - but currently it is the way it is. At least this is an issue I hope to address in a later version.
So if you are looking for special information, here is a short overview on what to find where:
- Code formatting hints are covered in Usage/CodeArrangement
- Usage/OracleForms deals with specifica of Oracle Forms
- Details on how to use Javadoc best can be found in JavaDoc
- Configuration issues are handled in Configuration
If you feel some information missing here, please let me know. The easiest (and best) way to do this is to open a ticket - but if you prefer to write a mail, you find a suitable link at the bottom of each page here.