Can you try
FormatStyle.Basic.Formatter for DML
FormatStyle.Ddl.Formatter for DDL

Tuna Toksöz
Eternal sunshine of the open source mind.

http://devlicio.us/blogs/tuna_toksoz
http://tunatoksoz.com
http://twitter.com/tehlike




On Sun, Sep 13, 2009 at 2:59 PM, DomZ <[email protected]> wrote:

>
> I have a page in my web application that contains a textarea field, in
> this field the user can write a sql query and send it to database.
>
> I would like to add a button "Format SQL" on this page.
>
> Also, at this time, the query is executed using ADO.NET (not NH), so
> may be there is a public method that I can use (like the one that
> exist in Java lib).
> If I can't use it, I will change the code to use ISQLQuery.
>
> On 13 sep, 20:10, Tuna Toksoz <[email protected]> wrote:
> > For what reason do you need it? There is a way if i recall correct, but
> tell
> > me.
> >
> > Tuna Toksöz
> > Eternal sunshine of the open source mind.
> >
> >
> http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike
> >
> >
> >
> > On Sun, Sep 13, 2009 at 2:08 PM, DomZ <[email protected]> wrote:
> >
> > > Thanks guys,
> >
> > > I was looking for something that can be set/unset at runtime
> >
> > > On 13 sep, 19:38, Fabio Maulo <[email protected]> wrote:
> > > > In the configuration.
> > > >  <property name="format_sql">true</property>
> >
> > > > 2009/9/13 DomZ <[email protected]>
> >
> > > > > Hi Guys,
> >
> > > > > I read that Hibernate library has a SQL Beautifier inside (in
> > > > > org.hibernate.pretty.Formatter)
> >
> > > > > It's used like that :
> > > > > String formattedSQL = new Formatter(sql).format()
> >
> > > > > I'm looking for the same thing in NH and had a look at the API
> > > > > reference but I haven't find such thing :(
> >
> > > > > Did I miss something ?
> >
> > > > > Is there any plan to support that (if it's not already done) ?
> >
> > > > > Thanks
> >
> > > > --
> > > > Fabio Maulo- Masquer le texte des messages précédents -
> >
> > > > - Afficher le texte des messages précédents -- Masquer le texte des
> messages précédents -
> >
> > - Afficher le texte des messages précédents -
> >
>

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to