Forum Post: RE: Use-index prevent multiple brackets: documented?

  • Thread starter Thread starter S33
  • Start date Start date
Status
Not open for further replies.
S

S33

Guest
A better approach to solve the real issue is to create a workfile or temp-table and populate it with the 4 values for status, and then use that in the "for each" to make better use of the keys. def temp-table tt1 no-undo field s as c. do transaction: create tt1. tt1.s = 'w'. create tt1. tt1.s = 'x'. create tt1. tt1.s = 'y'. create tt1. tt1.s = 'z'. end. for each tt1 no-lock, each table where table.code = 'a' and table.status = tt1.s and table.log = false:

Continue reading...
 
Status
Not open for further replies.
Back
Top