Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Adding some dates
06-11-2012, 11:41 AM,
#16
RE: Adding some dates
Hi all:

it's becoming a constructive brain storming ;-)

1) Tim's proposal I think is the most flexible but also I think it means a very large revision of all the scripts. It could be done just with a flag "active record" and then add a AND stockmaster.activerecord = 1 to all queries, but even so it's a major work. BUT on the long run would be the best one.

2) Following Phil's last post idea we could have a table stockmasterchanges with:
stockid,
fieldname,
oldvalue,
newvalue,
date
That will allow to add more fields (not only the stockcategory).

3) Exson's idea to add the creation date of a stockmaster record is also wise. For how long did we had this item? is a useful question. Now we could reply by indirect means (first PO, first WO, first reception, etc) but not a direct one.

4) I'm still wondering if the performance penalty for adding just one (or a few) field to stockmaster is so large that makes sense to add a new JOIN on some queries. What is faster, retrieving an slightly larger record or producing a JOIN?

For the sake of simplicity of code I prefer number 4) but trying to get a good compromise that works Ok for everyone I think we could go for option 2) and 3).
Regards,
Pak Ricard
Reply


Messages In This Thread
Adding some dates - by PakRicard - 06-06-2012, 05:42 PM
RE: Adding some dates - by opto - 06-07-2012, 07:56 AM
RE: Adding some dates - by PakRicard - 06-07-2012, 11:47 AM
RE: Adding some dates - by phil - 06-07-2012, 12:00 PM
RE: Adding some dates - by PakRicard - 06-07-2012, 05:22 PM
RE: Adding some dates - by phil - 06-07-2012, 06:26 PM
RE: Adding some dates - by PakRicard - 06-09-2012, 05:09 PM
RE: Adding some dates - by PakRicard - 06-08-2012, 10:40 AM
RE: Adding some dates - by phil - 06-09-2012, 06:21 PM
RE: Adding some dates - by PakRicard - 06-09-2012, 07:54 PM
RE: Adding some dates - by phil - 06-10-2012, 01:31 PM
RE: Adding some dates - by PakRicard - 06-10-2012, 02:22 PM
RE: Adding some dates - by Exsonqu_Qu - 06-10-2012, 08:42 PM
RE: Adding some dates - by phil - 06-11-2012, 07:35 AM
RE: Adding some dates - by PakRicard - 06-11-2012, 11:41 AM
RE: Adding some dates - by phil - 06-12-2012, 08:46 AM
RE: Adding some dates - by PakRicard - 06-12-2012, 12:05 PM
RE: Adding some dates - by Exsonqu_Qu - 06-13-2012, 01:27 PM
RE: Adding some dates - by PakRicard - 06-14-2012, 06:29 PM
RE: Adding some dates - by phil - 06-14-2012, 07:02 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)