Should have read "LEFT() is defined in MSSql2000Dialect", etc.
On Sep 2, 4:15 pm, nerode <[email protected]> wrote:
> LEFT() is defined in MSSqlDialect, which is extended by the 2005
> dialect (and again 2008 extends 2005). CAST has also stopped working,
> and is not defined in these Dialect files (CONVERT works).
>
> On Aug 14, 6:47 am, Fabio Maulo <[email protected]> wrote:
>
> > have a look to the dialect you are using and let me know if the LEFT
> > function is there or not.Thanks.
>
> > 2009/8/13 nerode <[email protected]>
>
> > > Other than the fact tha I can find no documentation on this (any links
> > > appreciated), I've found a change from the previous parser: a
> > > statement that is designed to be executed against MSSqlServer (2000 or
> > > 2005 dialect) used to accept the function LEFT(value, count). This
> > > now throws a NoViableAltException. Replacing it with SUBSTRING(value,
> > > 1, count) works.
>
> > > Is this intended? Can someone identify otherfunctionsthat once
> > > worked but will now fail (at runtime)?
>
> > --
> > Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
