Unfortunately, doing this seems to remove the onthefly column from the select spec completely.
Also, I had trouble testing this properly but I think that even if lazy, when I do include the onthefly column in the select spec, it still complains that the field doesn't exist. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John > Siracusa > Sent: 27 June 2007 00:10 > To: Rose::DB::Object list > Subject: Re: [RDBO] on the fly fields > > > On 6/26/07, James Masters <[EMAIL PROTECTED]> wrote: > > I decided to use the prefix C_ to identify "onthefly" > fields. The problem > > with this was that the damn field didn't actually exist so > Rose Manager > > immediately barfed saying "Unknown column C_sourcedate" - > whether the column > > was used or not. > > > > The only way around this that I could think of was to > actually create the > > field in the real table - so I created a "dummy" field in > MySQL - all data > > set to NULL. Then it worked. (can anyone think of another way?) > > How about making the column lazy? (Add lazy => 1 to the column spec.) > > -John > > -------------------------------------------------------------- > ----------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
