Using Views in Torque

[Jeffrey Wong <mi...@cptn.net>]

Is it possible to have Torque generate objects that reference views and
not actual data tables?

I've considered defining the view in the schema xml and just not using
the generated SQL.  Is there a way to set it up so the object also
contains references to the tables from which the view was created.


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

Getting the Next Id Value

[Femi Aluko <if...@yahoo.com>]

Hi all,

I would like to get the next Id value generated by the IdBroker service so that i can insert it into one of the fields of a column that i want to insert into the table.

Is there any method that can return the next Id ?


		
---------------------------------
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�

Re: Using Views in Torque

[David Hainlin <dh...@comcast.net>]

Hi Jeffrey, I use this often when the corresponding joins are too 
complex or if I want summary info from more than one table.  This works 
great for read/query only situations.  I've not tried anything more 
adventurous with views.  Don't think your schema/objects can reference 
the tables the view is based on tho (other than comments/description 
entries).  HTH.
David

Jeffrey Wong wrote:

>Is it possible to have Torque generate objects that reference views and
>not actual data tables?
>
>I've considered defining the view in the schema xml and just not using
>the generated SQL.  Is there a way to set it up so the object also
>contains references to the tables from which the view was created.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>  
>

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