That would work, Buddy. Remember this column is not indexed, so the
questions becomes:
What SELECTs multiple rows faster - a specific value or a null value?
Which is what Nicky's approach was asking.
Doug
On 6/18/2025 4:30 PM, 'Buddy Walker' via RBASE-L wrote:
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
<[email protected]> 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 <[email protected]> wrote:
On Wednesday, June 18, 2025 at 02:31:55 PM CDT, Doug Hamilton
<[email protected]> <mailto:[email protected]> 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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com
<https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com?utm_medium=email&utm_source=footer>
.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/114B88D7-E622-451B-9415-F9CB7C27413C%40comcast.net
<https://groups.google.com/d/msgid/rbase-l/114B88D7-E622-451B-9415-F9CB7C27413C%40comcast.net?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
www.avast.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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/fd90a573-442a-44eb-94af-16bfefaaea4c%40wi.rr.com.
