11/29/2024 6:28:08 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum for off topic and general discussion. View the code of conduct for posting guidelines.
|
|
|
|
How Is This Field Being Populated
Posted: 14 Feb 08 2:56 PM
|
| We use SLX for order entry, and then migrate our orders into Mas500. Upon inserting a sales order, migrating an order, tsoSalesOrder is populated with data pertaining to the order. What I cannot figure out is the procedure that is doing this. I have tried using SQL Profiler, but cannot find any kind of SQL statement of type Insert or Update for that table. Does anyone have suggestions as to how I might be able to figure this one out? My intentions here are not for specifics given most SLX setups appear different, but just to hear something that might move me towards the right direction. |
|
|
| |
|
Re: How Is This Field Being Populated
Posted: 15 Feb 08 7:41 AM
|
| We do use DynaLink, but we use it to migrate information from Mas500 back into SLX. I have a feeling this will end up being something small and obvious. Correct me if I am wrong, but I would think somewhere there would have to be code or a sproc that states the name of the table being inserted into, tsoSalesOrder. |
|
|
|
Re: How Is This Field Being Populated
Posted: 15 Feb 08 2:34 PM
|
For an update:
Upon running SQL Profiler again, I did see an insert statement for a similarly named table, stgSalesOrder, however that table does not contain the data I am looking for, nor are there any triggers that might account for the transfer/deletion of data. I have looked through several triggers for the SLX db as well as the Mas500 db, but none are showing what I would hope... |
|
|
|
Re: How Is This Field Being Populated
Posted: 18 Feb 08 10:30 AM
|
| I ran the SQL profiler again, this time using the template for SLX from the utilities section of this site. I now know the stored procedure that is created the record in tsoSalesOrder. However, I am weary of altering this given it was installed with Mas500. This stored procedure is not called directly from SLX, so I will have to take some more time to see what triggers this sproc. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|