I'm fairly new to jOOQ, so please bear with me if I have missed something...

I generated the code using the Gradle plugin and jOOQ version 3.2.2.

When I attempt to run a query:

Record rec = create.select(

CUSTOMER.NAME.as("name"), 

CUSTOMER.CODE.as("code"), 
concat(

val("/v3/customer/"), 

CUSTOMER.CODE, 

val("/vdc")).as("vdc")) 

.where(CUSTOMER.CODE.eq(code))

.fetchOne();


When I try to retrieve values, the values are not correlated properly. 
Example:

rec.getValue("name");    // Contains 'null'
rec.getValue("code");    // Contains the 'name' value
rec.getValue("vdc");     // Contains the 'code' value
rec.getValue(0);         // Contains 'null'
rec.getValue(1);         // Contains the 'name' value 
rec.getValue(2);         // Contains the 'code' value 
rec.getValue(3);         // Throws an exception saying invalid field option

Can anyone suggest where I might be going wrong?

Thanks in advance!!!

Deven

-- 
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/d/optout.

Reply via email to