RE: Escaping SQL names in torqu

Hi.

Thanks for the answer ;)


The problem with the reserved file words is that I'm working with a large
project model that was made between different companies and they agreed on
it. So I have to stick with it :(

I'm trying the velocity templates, but can anyone show me an example of how
to do it? Db-init or base? I'm a little lost with the templates :(


Thanks again.


-----Mensagem original-----
De: Thomas Fischer [mailto:Fischer@xxxxxxxxxxxxx] 
Enviada: sexta-feira, 26 de Novembro de 2004 9:02
Para: Apache Torque Users List
Assunto: RE: Escaping SQL names in torqu





Hi Pedro,

you can change the velocity templates which are used to create the sql
scripts . They can be found in the generator in the subdirectory
templates/sql.
However, I would _NOT_ use reserved words as table or column names if I
were you. I would be surprised if the sql scripts are the only difficulty
you run into. For example, my guess is that you cannot do selects on tables
which names are reserved words.

    Thomas

"Pedro Castro" <pfc@xxxxxxxxxx> schrieb am 25.11.2004 19:30:33:

> Hello all.
>
>
>
> Anyone knows how I can make torque to surround table names with the right
> escape chars. For example in Sql Server to escape reserved words I would
use
> brackets:
>
>
>
>             CREATE TABLE [File]
>
>             .
>
> Or, in MySql:
>
>
>
>
>
>             CREATE TABLE "File"
>
>
>
>
>
> Is it possible to change torque to do this according to the selected
> database (even if it is needed to tell torque which is the right char)?
>
>
>
> Thank you very much.
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@xxxxxxxxxxxxx
For additional commands, e-mail: torque-user-help@xxxxxxxxxxxxx