Doing your proposed workaround would not work for me either, I never call the SQL with the same station.
I am not sure if this changes your understanding of wheter the expression should have been cached. Looking at the SQL logged Select SQL: SELECT ps$.PICK_SLOT_ID, ps$.X_COORD, ps$.Y_COORD, ps $.Z_COORD, ps$.MAX_WEIGHT, ps$.TU_TYPE, ps$.MACHINE_ID, ps $.REPLEN_LOC_ID, ps$.OLD, ps$.SKU_ID, s$.EACH_VOLUME, s$.EACH_WEIGHT, s $.BAG_SEGREGATION_DAMAGE, s$.BAG_SPACE, s$.COMMONALITY, s $.WINE_HOLDER, s$.DESCRIPTION, s$.EACH_HEIGHT, s$.EACH_WIDTH, s $.EACH_LENGTH, s$.SAMPLE FROM WMSADH.PICK_SLOT ps$ LEFT JOIN WMSADH.SKU s$ ON ps$.SKU_ID = s$.SKU_ID WHERE ps$.STATION_ID = :Value Should it cache the query without the Value so it can be called regardless of whether different values are used. I will try the debugging Pascal suggested. Cheers, James --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
