Re: [RBASE-L] - Speeding up SELECT WHERE ColName IS NULL

['Buddy Walker' via RBASE-L]

Doug What I have done in the past was set the default value to some off the date like 12/31/1899 then print your labels where the date = 12/31/1899   Buddy Sent from my iPhone On Jun 18, 2025, at 4:41 PM, 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com> wrote:  Nick:  His    LabelsPrintedDTS field is a DATETIME or DATE, as far as I can tell Karen On Wednesday, June 18, 2025 at 03:36:00 PM CDT, 'Nicky Avery' via RBASE-L <rbase-l@googlegroups.com> wrote: On Wednesday, June 18, 2025 at 02:31:55 PM CDT, Doug Hamilton <bugl...@wi.rr.com> wrote: Labels to be printed are selected WHERE LabelsPrintedDTS IS NULL. Doug, when you create a new order, had you tried assigning a default value of 0 to LabelsPrintedDTS rather than no value? Once printed, you can change it to 1. This way you search on ... WHERE LabelsPrintedDTS = 0 rather than NULL. Nicky -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/114B88D7-E622-451B-9415-F9CB7C27413C%40comcast.net.