75
Hello,
We are trying to insert an event row in the SoEvent Table to signal a report has been printed. In looking at the EventId field, it is obviously not a uniqueidentifier or an auto-incrmeneted field so we haven't been able to figure out how this can be generated.
Any thoughts on generating a valid eventID to insert in the SOEvent Table
Thanks
*This post is locked for comments
[CpnyID] ASC,
[OrdNbr] ASC,
[ShipperID] ASC,
[EventID] ASC
Is the primary key. Still do not understand why you want to insert into that table, why not to add a status to a SO - Report being Printed.
I suggest just calling stored procedure 'ADG_SOEvent_Create' to create a log entry. It takes the following parameters:
@cpnyid varchar(10),
@descr varchar(30),
@eventtype varchar(4),
@ordnbr varchar(15),
@progid varchar(8),
@shipperid varchar(15),
@userid varchar(10)
@shipperid is specified when the entry pertains to a shipper, otherwise it is left blank.
The SOEvent table does use an identity field for EventID (for version 7 anyway), so you should be able to insert without specifying a value. Or use the above procedure whose text shows how it is done.
Valid values for eventtype:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (