Hi,

Just wanted to confirm that I wasn't missing out on a known 'trick' in order to get round this 'issue'.

Seems strange to me that you can reference the record using a scan but the select doesn't pick up the uncommitted records!

Thanks, Hector,