E10 InTransactionData Directive

Yahoo Archive
1

Got it working

 

Thanks

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 10, 2015 1:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 InTransactionData Directive

 




I am making a data directive to write to a log file changes to the OrderRel table.

 

I have it somewhat working comparing 'old' record to 'new' record EXCEPT

When it is a newly created row - then the 'old' record doesn't exist

 

so, my question...

how do I create a new blank ttOrderRel row to assign to my 'old' record?

 

thanks

bw




2

I am making a data directive to write to a log file changes to the OrderRel table.


I have it somewhat working comparing 'old' record to 'new' record EXCEPT

When it is a newly created row - then the 'old' record doesn't exist


so, my question...

how do I create a new blank ttOrderRel row to assign to my 'old' record?


thanks

bw

3

Are you trying to log something that can’t be done with a regular change log data directive?  The change log feature for a table should log any field you select for add or update and list the before and after values along with who did it and the date/time.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 10, 2015 12:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 InTransactionData Directive

 

 

I am making a data directive to write to a log file changes to the OrderRel table.

 

I have it somewhat working comparing 'old' record to 'new' record EXCEPT

When it is a newly created row - then the 'old' record doesn't exist

 

so, my question...

how do I create a new blank ttOrderRel row to assign to my 'old' record?

 

thanks

bw

4

Yes I am aware of this – This is a special request to email out a list of order changes to program mangers, buyers etc so they don have to try and figure out what changed for themselves

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 10, 2015 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E10 InTransactionData Directive

 




Are you trying to log something that can’t be done with a regular change log data directive?  The change log feature for a table should log any field you select for add or update and list the before and after values along with who did it and the date/time.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 10, 2015 12:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 InTransactionData Directive

 

 

I am making a data directive to write to a log file changes to the OrderRel table.

 

I have it somewhat working comparing 'old' record to 'new' record EXCEPT

When it is a newly created row - then the 'old' record doesn't exist

 

so, my question...

how do I create a new blank ttOrderRel row to assign to my 'old' record?

 

thanks

bw