Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking design
Message
From
23/02/2015 18:19:05
 
 
To
23/02/2015 18:03:38
General information
Forum:
ASP.NET
Category:
Databases
Title:
Environment versions
Environment:
VB 9.0
OS:
Windows 8.1
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01615752
Message ID:
01615753
Views:
41
The only way I have found so far that would be certain that I do not have duplicate record is to create a task with the minimum interval, thus it would run every 15 seconds. That task will simply have a responsibility to create the daily record. If other robots are in need of the daily record and it would not be yet available, that would be from midnight + 15 seconds, I could establish a 15-second wait time with a retry to grab the daily record after, as it would then be created from the new task.

If someone has an alternate design, I would be happy to see if I can use it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform