Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of greg.monroe@dukece.com
 designates 152.3.166.24 as permitted sender)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Using views
Date: Mon, 12 Mar 2007 09:17:42 -0400
Message-ID: <8F5843B903F59D4C8C6806BB49A3911902AF389E@dukece-mail3.dukece.com>
In-Reply-To: <45F4A0D2.2010906@gmail.com>
Thread-Topic: Using views
Thread-Index: AcdkPr3UTFgR3JLRRCGMRJFrTuVzFgAaSKbg
References: <45F36732.9020803@gmail.com> <45F41626.3090409@brekke.org>
 <45F4A0D2.2010906@gmail.com>
From: "Greg Monroe" <Greg.Monroe@DukeCE.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

FWIW, by definition in SQL, views are the same as tables=20
except that some fields may not be writable.  So, defining
them as tables in Torque will work for all DBs.

One minor thing to do when defining the XML for these is
to add the skipSql=3D"true" attribute to the table definition.
This will cause this table to be skipped in any generator=20
sql creation.

Also, full support for views is on the list for version 4.0=20
(but that will be a while).

> -----Original Message-----
> From: Hern=E2ni Cerqueira [mailto:hrcerqueira@gmail.com]=20
> Sent: Sunday, March 11, 2007 8:38 PM
> To: Apache Torque Users List
> Subject: Re: Using views
>=20
> Jeff Brekke escreveu:
> > Hern=E2ni Cerqueira wrote:
> >> Hello all,
> >>
> >> First of all i want to comment to any torque creator or developer=20
> >> under here that this tool is perfect. I don't know how did=20
> i spend so=20
> >> much time without it. Sorry if this isn't the right place=20
> for those=20
> >> kibd of coments but i didn't know where to do that.
> >>
> >> And now, my doubt. Is i possible to use views with torque. I've=20
> >> already searched documentation about that, and i didn't find=20
> >> anything, so i have few hopes, but anyway...
> >
> > Dependant on the database you're using, but we have=20
> successfully used=20
> > them with Sybase.  Just have the view name the same as the=20
> table name=20
> > your using in your definition.
> >
> I already did that with pg, but i thought that it wasn't the=20
> right solution. But that's cool, now i know that my solution=20
> it's not a bad one, ;-)
>=20
> Thank's for the repy
> Hern=E2ni
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>=20
>=20

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are =
confidential communication or may otherwise be privileged or =
confidential and are intended solely for the individual or entity to =
whom they are addressed.  If you are not the intended recipient you may =
not rely on the contents of this email or any attachments, and we ask =
that you  please not read, copy or retransmit this communication, but =
reply to the sender and destroy the email, its contents, and all copies =
thereof immediately.  Any unauthorized dissemination, distribution or =
copying of this communication is strictly prohibited.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org