[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Clarification on logical in query

  • Thread starter Thread starter jquerijero
  • Start date Start date
Status
Not open for further replies.
J

jquerijero

Guest
[quote user="frank.meulblok"] It could be that I misread, yes. Hopefully @jquerijero can elaborate ? [/quote] It's writing a query involving a logical field. Which of the following constructs are better? FOR EACH table WHERE table.active = YES NO-LOCK: or FOR EACH table WHERE table.active NO-LOCK: FOR EACH table WHERE table.active = NO NO-LOCK: or FOR EACH table WHERE NOT table.active NO-LOCK:

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