SQL Cursor limitations?

Darren Reely darren.reely at latticesemi.com
Wed Aug 17 13:30:43 CDT 2005


Whittall, Conrad wrote:
> PowerHouse uses only ANSI-SQL, not any particular database vendor's
> flavour. The ANSI SQL substring function is SUBSTRING, not SUBSTR. For
> example,
> 
> SUBSTRING(x FROM 1 FOR 12)

That is important to understand. Even though SUBSTRING() can't be used 
in Oracle's SQLPlus (version 8.1), it does work in Quiz.

Thanks for the tip Conrad, and the timing.

Darren


More information about the powerh-l mailing list