I like to be a good programmer citizen, and that means issuing my SQL*Server requests with a nolock. Is there a way to do this in native FOCUS code?

This message has been edited. Last edited by: FP Mod Chuck,

No sure what version of WF you are using. So, from the 8201M docs, this might answer your question. Syntax: How to Specify Transaction Isolation Level From a SET Command

NOLOCK Is equivalent to READUNCOMMITTED. So, you would use the RU option.

I doubt that being a good programmer citizen has anything to do with uncomitted / dirty reads

quote:

Originally posted by Hallway:
No sure what version of WF you are using. So, from the 8201M docs, this might answer your question. Syntax: How to Specify Transaction Isolation Level From a SET Command

NOLOCK Is equivalent to READUNCOMMITTED. So, you would use the RU option.

Yikes! So if I set using that command I can issue a TABLE FILE request and it will adhere to the restriction, yes? I should put SQL SQLMSS SET ISOLATION RU; at the beginning of the focexec to achieve the result? The documentation isn't very clear on that.

quote:

Originally posted by Frans:
I doubt that being a good programmer citizen has anything to do with uncomitted / dirty reads

I recycle too.

John

If you want this to be a global setting put it in the server profile (edasprof.prf) and all reports will use this setting.