Quote:
Originally Posted by RERomine
I'm not sure if you have tools that can do a compare between different versions of an OOB. If not, MS Word does a nice job of comparing .CSV files and can handle a pair of files at least 370KB each.
Cheers,
Ray
|
We have an extensive data check system but looking for any fighter bomber with more bombs than it should have is a rather specialized question. We could spend hours and hours dreaming up questions that could all come back blank
This would find it though but realistically why would we ask that question unless we suspected an error like that and who would suspect an error like this for a unit that's been perfectly OK since winSPWW2v1.0?
Don
Quote:
SELECT DISTINCT
D.NationID,
D.Slot,
D.Name,
D1.NationID,
D1.UnitSlot,
D.Unitclass,
D1.WeaponSlot,
D1.Weapon,
D2.WeaponName,
D1.HEAmmo,
D2. HEKill,
D1.APAmmo,
D.LastYearAvailable
FROM
"Units.DB" D,
"UnitWeapons.DB" D1,
"Weapons.DB" D2
WHERE
(D1.NationID = D.NationID)
AND (D1.UnitSlot = D.Slot)
AND (D2.NationID = D1.NationID)
AND (D2.WeaponID = D1.Weapon)
AND( D1.HEAmmo >8)
AND ( D. Unitclass = 44)
AND (D2. HEKill >15)
|
and there is a lot of ways to write this that would miss that error and no we don't do comparisions of one OOB from the previous version becasue there are usually hundreds of changes made