Darren Duncan wrote:
It would help me and a lot of other people the most if you simply supported the ":foo" format for named bind variables.
Perhaps someone can enlighten me as to exactly what that format is? A colon followed by any number of alphanumerics? What about underscores? Does there need to be a second colon terminator? Where can I find specifics?
The short answer to this, I believe, is that this format involves a colon followed by any of the exact same characters that are allowed in standard SQL identifiers such as table or view or column or trigger names.
In your case, just make it the same as what you allow for table names, etc, but there is a single leading colon.
I'm looking up a longer answer now, with references in the SQL standard docs.
Meanwhile, look here: http://www.wiscorp.com/SQLStandards.html
Click on the link "SQL:2003 Documents", which is a zip file of about 1MB in size, containing the full SQL:2003 spec in PDF format.
-- Darren Duncan
