Thanks Tony, I do put them into a temp table - but I still have select
the unprinted labels to put into the temp table.
Doug.
On 6/19/2025 2:11 AM, 'Tony IJntema' via RBASE-L wrote:
Why don't you create a temp table, containing all the rows to be printed.
Tony
Op 19-06-2025 om 04:15 schreef Doug Hamilton:
Karen is correct, LabelsPrintedDTS is DateTime cuz we want to know
when the labels were printed.
Assigning 0 or 1 is what the Boolean calculated column is doing
automatically.
The question about when calculated columns are evaluated remains.
Doug
Go Packers
On 6/18/2025 3:41 PM, 'Karen Tellef' via RBASE-L 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> <mailto: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
<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 rbase-l+unsubscr...@googlegroups.com.
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>.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
Virus-free.www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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/f5345a84-4b6c-4247-af0d-613f333a1001%40wi.rr.com
<https://groups.google.com/d/msgid/rbase-l/f5345a84-4b6c-4247-af0d-613f333a1001%40wi.rr.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/989f9b74-a567-43fd-96f1-15c3a5e08c7f%40cio-bv.nl
<https://groups.google.com/d/msgid/rbase-l/989f9b74-a567-43fd-96f1-15c3a5e08c7f%40cio-bv.nl?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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/4b8c902e-2483-415c-b57f-a65f13e8f3ac%40wi.rr.com.
