Hi there, There is a difference between the selectFrom() API method and the select().from() methods. This difference is documented here: http://www.jooq.org/doc/3.2/manual/sql-building/sql-statements/select-statement/#N10A9B
Use the selectFrom() method only if you want to fetch UpdatableRecords, e.g. Table1Record. If you want to write arbitrary projections, write: ctx.select(Table1.fields()) .select(someStringColumn) .from(Table1) ... Cheers Lukas 2014/1/22 Stargate <[email protected]> > Hi, > > i have a normal sql query like this Record record = > DSLContext.selectFrom(Table1).fetch(); > > > and is it possible to add a new field to this record ? of course a String > Field with a value,how can i do this ? > > Best regards > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
