On Tue, 2009-07-07 at 09:08 +0200, Rails List wrote: > Will there be more typeabbrev than the specified 2?. Do you expect more > in the future?. If so, how many? > > If typeabbrev are only two for each stockid then why cant you put them > in stockmaster itself?. > > Alternatively, you can have a Prices table with multiple columns with > each column representing typeabbrev... > > please provide more info... ---- this is legacy db from weberp accounting (php) and I can't do much about it but to live with it.
the way this 'prices' is setup, typeabbrev field is useful only if you have labeled categories, which I presently have 2, Wholesale and Retail and maybe will have more in the future. but this file could also have a special 'customer' price for a matching stock item which would be null in typeabbrev. But the reality is that I can't change anything here without having to tackles some rewrite of the accounting software and that is not going to happen. Thanks Craig -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
