D3 Windows triggers
50 views
Skip to first unread message
CDMI - Steve T
May 19, 2025, 11:39:42 AMMay 19
to Pick and MultiValue Databases
I have a D3/Windows client and I believe a particular file is behaving like there is a 'callx' going on, but for the life of me, I can NOT find where / when this callx is taking place.
I found this code in one of their program files:
snippet:
SUBROUTINE PROCESS.HARVEY.SHIP.SUB(ITEM)
OPEN 'HARVEY_SHIP' TO HARVEY.SHIP ELSE STOP
OPEN 'PROCESS.SHIP.HARVEY.RELEASE' TO PROCESS.SHIP.RELEASE ELSE STOP
OPEN 'WAITING' TO WAITING ELSE STOP
ITEM = ACCESS(3)
ID = ACCESS(10)
DEL.FLAG = ACCESS(12)
IF DEL.FLAG THEN RETURN
READ REC FROM PROCESS.SHIP.RELEASE,ITEM<6> ELSE REC = ''
OPEN 'HARVEY_SHIP' TO HARVEY.SHIP ELSE STOP
OPEN 'PROCESS.SHIP.HARVEY.RELEASE' TO PROCESS.SHIP.RELEASE ELSE STOP
OPEN 'WAITING' TO WAITING ELSE STOP
ITEM = ACCESS(3)
ID = ACCESS(10)
DEL.FLAG = ACCESS(12)
IF DEL.FLAG THEN RETURN
READ REC FROM PROCESS.SHIP.RELEASE,ITEM<6> ELSE REC = ''
......
I see records in the file: PROCESS.SHIP.HARVEY.RELEASE
here is MD PROCESS.SHIP.HARVEY.RELEASE
001 D
002 $(mds):$(MD)/process.ship.harvey.release/process.ship.harvey.release
003 1
004
005
006
007
008
009 L
010 10
002 $(mds):$(MD)/process.ship.harvey.release/process.ship.harvey.release
003 1
004
005
006
007
008
009 L
010 10
I mainly work with commercial QM and it has a wonderful feature:
LIST.TRIGGERS
and it shows all the triggers available / running on the current account you are logged on to.
Does D3/Windows have any thing like it?
I am at a loss not being able to track this down. The 'HARVEY' is some kind of local shipping system and it is connecting and talking via ODBC.
They are changing to ShipStation but I can't figure out how 'HARVEY' gets populated. I need to find it and convert to ShipStation API(s).
Any help will be greatly appreciated.
Thanks in advance,
Steven Trimble
philippe GRACIA
May 19, 2025, 11:54:55 AMMay 19
to mvd...@googlegroups.com
hello.
you can find the trigger ( callx) in dict of the file file, att 8.
ct dict stock/usa stock/usa displays:
stock/usa
001 D
002 6339507
003 3449
004
005
006
007
008 callx callx.stock.internet.usa
009 L
010 10
011
012
013
001 D
002 6339507
003 3449
004
005
006
007
008 callx callx.stock.internet.usa
009 L
010 10
011
012
013
the doc is here :
be careful with triggers in D3 windows, There is a particularity on execution: the trigger is reloaded in each session only on close/reopen file !! read the help section for nt_inv_flash ( we still don't really understand how it works!)
--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms
---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com.
Steven Martin Trimble
May 19, 2025, 1:13:31 PMMay 19
to mvd...@googlegroups.com
I can NOT find the file (if this is actually what is going on)
Is there a way to find the triggers in D3 like commercial QM does with LIST.TRIGGERS?
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com.
geneb
May 19, 2025, 1:23:58 PMMay 19
to mvd...@googlegroups.com
Steven, you might try using the "find2" command and search the entire
system for the name of the subroutine.
Something along the lines of this:
:find2
Enter the output file name ?
Enter the search string ?test string
Enter the search string ?
START LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File ?0
STOP LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File.?3
It might take a while, depending on the size of the system, but it will
find it. ;)
g.
On 5/19/2025 10:13 AM, Steven Martin Trimble wrote:
> I can NOT find the file (if this is actually what is going on)
> Is there a way to find the triggers in D3 like commercial QM does with
> LIST.TRIGGERS?
>
> *CDMI*
> *Steven Trimble*
> /(501) 772-3450 cell/text/
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
system for the name of the subroutine.
Something along the lines of this:
:find2
Enter the output file name ?
Enter the search string ?test string
Enter the search string ?
START LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File ?0
STOP LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File.?3
It might take a while, depending on the size of the system, but it will
find it. ;)
g.
On 5/19/2025 10:13 AM, Steven Martin Trimble wrote:
> I can NOT find the file (if this is actually what is going on)
> Is there a way to find the triggers in D3 like commercial QM does with
> LIST.TRIGGERS?
>
> *Steven Trimble*
> /(501) 772-3450 cell/text/
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the
> Google Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from
> it, send an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com
> <https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com?utm_medium=email&utm_source=footer>.
> ---
> You received this message because you are subscribed to the
> Google Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from
> it, send an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com
>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
Steven Martin Trimble
May 19, 2025, 1:25:53 PMMay 19
to mvd...@googlegroups.com
wonderful I will definitely try that
really appreciate it
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/bb08cc82-729d-4314-a41c-ac941ec8052f%40deltasoft.com.
geneb
May 19, 2025, 1:42:28 PMMay 19
to mvd...@googlegroups.com
On 5/19/2025 10:25 AM, Steven Martin Trimble wrote:
> wonderful I will definitely try that
> really appreciate it
>
g.
Steven Martin Trimble
May 19, 2025, 3:28:30 PMMay 19
to mvd...@googlegroups.com
Hey, does D3 have a 'system()' function or other function that I can query 'what program' just updated a particular file?
So, I'd like to put a callx in the WAITING file to find out what program 'just' updated the 'WAITING' data file. I call it my 'WHEREFROM' value. Very helpful debugging and learning a new system.
thanks in advance,
On Mon, May 19, 2025 at 12:23 PM geneb <ge...@deltasoft.com> wrote:
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/bb08cc82-729d-4314-a41c-ac941ec8052f%40deltasoft.com.
Steven Martin Trimble
May 19, 2025, 4:59:31 PMMay 19
to mvd...@googlegroups.com
I found that rascal
thanks sir gene!!
On Mon, May 19, 2025 at 12:23 PM geneb <ge...@deltasoft.com> wrote:
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/bb08cc82-729d-4314-a41c-ac941ec8052f%40deltasoft.com.
geneb
May 19, 2025, 5:13:48 PMMay 19
to mvd...@googlegroups.com
YW!
On 5/19/2025 1:59 PM, Steven Martin Trimble wrote:
> I found that rascal
> thanks sir gene!!
>
> > <mailto:mvdbms%2Bunsu...@googlegroups.com
> <mailto:mvdbms%252Buns...@googlegroups.com>>
> <mailto:mvdbms%252Buns...@googlegroups.com>>
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6DM-kXj6yX2dSc2m7X20kz%3D2Aoy_k5h3mZkFfRyeMU_w%40mail.gmail.com?utm_medium=email&utm_source=footer>.
On 5/19/2025 1:59 PM, Steven Martin Trimble wrote:
> I found that rascal
> thanks sir gene!!
>
> <mailto:mvdbms%252Buns...@googlegroups.com>>
> > For more options, visit
> http://groups.google.com/group/mvdbms
> > ---
> > You received this message because you are subscribed to the
> > Google Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails
> from
> > it, send an email to mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>.
> http://groups.google.com/group/mvdbms
> > ---
> > You received this message because you are subscribed to the
> > Google Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails
> from
> > it, send an email to mvdbms+un...@googlegroups.com
> > To view this discussion visit
> >
> https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com
> >
> <https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com?utm_medium=email&utm_source=footer>>.
> >
> > --
> > You received this message because you are subscribed to
> > the "Pick and MultiValue Databases" group.
> > To post, email to: mvd...@googlegroups.com
> > To unsubscribe, email to:
> mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> > <mailto:mvdbms%2Bunsu...@googlegroups.com
> >
> https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com
> >
> <https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/76488630-1959-4c87-9ffb-2c8995f609bcn%40googlegroups.com?utm_medium=email&utm_source=footer>>.
> >
> > --
> > You received this message because you are subscribed to
> > the "Pick and MultiValue Databases" group.
> > To post, email to: mvd...@googlegroups.com
> > To unsubscribe, email to:
> mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> <mailto:mvdbms%252Buns...@googlegroups.com>>
> > For more options, visit http://groups.google.com/group/mvdbms
> > ---
> > You received this message because you are subscribed to the
> Google
> > Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails
> from it,
> > send an email to mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>.
> > ---
> > You received this message because you are subscribed to the
> > Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails
> from it,
> > send an email to mvdbms+un...@googlegroups.com
> > To view this discussion visit
> >
> https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com
> >
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer>>.
> >
> > --
> > You received this message because you are subscribed to
> > the "Pick and MultiValue Databases" group.
> > To post, email to: mvd...@googlegroups.com
> > To unsubscribe, email to: mvdbms+un...@googlegroups.com
> >
> https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com
> >
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/CAEn2%3DNqfYCurVp77RiCnamSXeg44JHFrh7W1-HrJ8QU4Y%2BDwWw%40mail.gmail.com?utm_medium=email&utm_source=footer>>.
> >
> > --
> > You received this message because you are subscribed to
> > the "Pick and MultiValue Databases" group.
> > To post, email to: mvd...@googlegroups.com
> > To unsubscribe, email to: mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> > For more options, visit http://groups.google.com/group/mvdbms
> > ---
> > You received this message because you are subscribed to the Google
> > Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails from
> it, send
> > an email to mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>.
> > For more options, visit http://groups.google.com/group/mvdbms
> > ---
> > You received this message because you are subscribed to the Google
> > Groups "Pick and MultiValue Databases" group.
> > To unsubscribe from this group and stop receiving emails from
> it, send
> > an email to mvdbms+un...@googlegroups.com
> > To view this discussion visit
> >
> https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com
>
> >
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer>>.
>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> >
> https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com
>
> >
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6sJHRF2PZiMs5eRAgYP%2BH23m6CdnbvBPNNuN1uOMGDmw%40mail.gmail.com?utm_medium=email&utm_source=footer>>.
>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to mvdbms+un...@googlegroups.com
> <mailto:mvdbms%2Bunsu...@googlegroups.com>.
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to mvdbms+un...@googlegroups.com
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/bb08cc82-729d-4314-a41c-ac941ec8052f%40deltasoft.com.
>
> https://groups.google.com/d/msgid/mvdbms/bb08cc82-729d-4314-a41c-ac941ec8052f%40deltasoft.com.
>
> --
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> https://groups.google.com/d/msgid/mvdbms/CAJDLGm6DM-kXj6yX2dSc2m7X20kz%3D2Aoy_k5h3mZkFfRyeMU_w%40mail.gmail.com
> You received this message because you are subscribed to
> the "Pick and MultiValue Databases" group.
> To post, email to: mvd...@googlegroups.com
> To unsubscribe, email to: mvdbms+un...@googlegroups.com
> For more options, visit http://groups.google.com/group/mvdbms
> ---
> You received this message because you are subscribed to the Google
> Groups "Pick and MultiValue Databases" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to mvdbms+un...@googlegroups.com.
> To view this discussion visit
> <https://groups.google.com/d/msgid/mvdbms/CAJDLGm6DM-kXj6yX2dSc2m7X20kz%3D2Aoy_k5h3mZkFfRyeMU_w%40mail.gmail.com?utm_medium=email&utm_source=footer>.
Reply all
Reply to author
Forward
0 new messages