Hello:

How can I get a db_select() "WITH (NOLOCK)", otherwise how to make a Tablesort with a pager from a db_query()?

Thanks for your answer.

Comments

omegamonk’s picture

omegamonk commented
Status: Active » Closed (works as designed)

daneelcm:
The Module Development and Code Questions forum would be a more appropriate spot for this question, rather than the SQL Server issue queue.

db_select has an options parameter, which should allow you to specify 'nolock' as an option, but it should be noted that 'nolock' is not recommended...

daneelcm’s picture

daneelcm commented
Status: Closed (works as designed) » Fixed

Sorry for use this way and thank's for the advise of use the forums to get answers of the drupal comunity. I try to use the option parameter but didn't work, and 'nolock' its not recommended but im forced to use it. See http://drupal.org/node/1852024#comment-6916554

Thanks

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.