FWIW, by definition in SQL, views are the same as tables 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="true" attribute to the table definition. This will cause this table to be skipped in any generator sql creation. Also, full support for views is on the list for version 4.0 (but that will be a while). > -----Original Message----- > From: Hernâni Cerqueira [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 11, 2007 8:38 PM > To: Apache Torque Users List > Subject: Re: Using views > > Jeff Brekke escreveu: > > Hernâni Cerqueira wrote: > >> Hello all, > >> > >> First of all i want to comment to any torque creator or developer > >> under here that this tool is perfect. I don't know how did > i spend so > >> much time without it. Sorry if this isn't the right place > for those > >> 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 > >> already searched documentation about that, and i didn't find > >> anything, so i have few hopes, but anyway... > > > > Dependant on the database you're using, but we have > successfully used > > them with Sybase. Just have the view name the same as the > table name > > your using in your definition. > > > I already did that with pg, but i thought that it wasn't the > right solution. But that's cool, now i know that my solution > it's not a bad one, ;-) > > Thank's for the repy > Hernâni > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
