Database Design & Discussion

We found out with the last couple of HCDB potential releases that the country names were not being imported correctly by the PE (Platform Editor). There is no problem exporting from the PE, just importing. The import does not error out but rather imports incorrect information for the higher numbered country names (has to do with a 1024 character limit so saying exactly where the problem shows up is difficult as it varies with each DB). For those of you MS Access fans, the import specification called bsStringsImport has a column set to a fixed length of 1024 characters. By modifying the import specification to 4096 characters it becomes more than wide enough to h…

Some notes on Swedish airforce in the DB: Note that there where few things more secret than missile loadouts and missile guidance in Swedish armed forces. I know the original rb24 (AIM-9b) bought from the US where eventually upgraded to AIM-9P and Swedish defence industry messed around with fuzes too but have not found any dates. As the designation Rb74 where used for both AIM-9L and AIM-9M (or atleast in some official text) JA37 (1979-98) Should not be able to use AMRAAM, the Standard load out would been 2 Skyflash and 4 AIM-9J/P (Rb 24J) / AIM-9L(Rb 74) (two of each where common on photos) from 1987 add 2 Flare dispensers (BOY401) without losing othe…

I'm about to upgrade the PE format from Access 97 to Access 2003 (so that it can be opened with Access 2003-2016 instead of the current Access 97 - 2010). Does anyone have big complaints about this? For those hanging on to Office 97 and 2000 you should be able to install a newer MS Access runtime (*free).

Type 26 City, Built for the United Kingdom's Royal Navy. Known as the Global Combat Ship to partially replace the navy's 13 Type 23 frigates, and for export (Canada, Austrialia). https://en.wikipedia.org/wiki/Type_26_frigate#cite_note-BAE-10 View full record

Looks like i stumbled over an error and some missing infos... No Info About Dipping and localizer/ranging and HF(3d) seems to be wrong. dipping should be easy to fill. => Sonar used by Helos and Ships, lowered when in use. In the game helos use dipping sonar only while hovering at vlow..... But for the two other fields I need more info to fix it.... How is it working in the game?

Sea Ceptor, CAMM is replacing the Sea Wolf missile on all ships that have the Sea Wolf missiles. It will have a 2 way data link and a Active RF seeker. https://en.wikipedia.org/wiki/CAMM_(missile_family) View full record

Brad, can u add the A109 in the DB? Here are references: Agusta A109 Helicopter http://www.ifrance.com/ArmyReco/europe/Bel...e_diaporama.htm http://www.ifrance.com/ArmyReco/europe/Ita..._helicopter.htm http://www.csd.uwo.ca/~pettypi/elevon/gust...l/A109AGUS.html http://www.rotorhead.org/military/a109.asp http://www.scramble.nl/mil/5/blu/a109.htm http://www.geocities.com/CapeCanaveral/Lau...5249/a109cm.htm http://www.nouki.ch/Avions/agusta-109.html http://www.brainyencyclopedia.com/encyclop...gusta_a109.html http://www.armada.ch/01-2/002.htm http://www.texelairport.nl/fotogroot/otara.htm http://www.helis.com/database/go/be_a109_134.php http://www.mil.be…

Sonar 2087 is a tactical, variable-depth, active and passive anti-submarine warfare (ASW) system to be fitted to Type 23 Frigates. It will replace the passive towed array Sonar 2031 and be integrated with the bow-mounted, active Sonar 2050 http://www.armedforces.co.uk/projects/raq3f8d4e1b8587c#.YrCgRuzMIuU View full record

Brad, Thanks for the newest version of the HCDB. Quick questions and requests (for the next version)... As far as I can tell, the F-35 JSF cannot attack ships. All of its strike loadouts are for land targets (some of them say SURF in the scenario editor but when I play the test scenario they switch over to LAND). Is this correct? Can you add the Spanish S-80 class submarines? (listed on the HazeGray site) Can you add the Mi-8 helicopter (carries troops and can be armed with rockets, etc.)...used by many armed forces around the world see http://www.fas.org/man/dod-101/sys/ac/row/mi-8.htm Since you've added the British CVs, could you add a C…

Type 31 FFG Inspiration class general purpose frigate. The Type 31 frigate will replace some of the general-purpose Type 23 frigates in service. The Type 31 frigates are also being built for the Polish (3) and Indonesian (2) navies. A total of 10 are planned. https://en.wikipedia.org/wiki/Type_31_frigate View full record

Well according to the game's database, a South Korean Aeigis ship(?)(KDX-3 King Sejong) is a frigate(FF). But I want to say that, it is actually a Destroyer(DDG). Its weight is 7650 tons, there is no way to be the huge ship is a frigate (considering KDX-2 is a destroyer(DDG) which is lighter than KDX-3) http://blogfile.paran.com/BLOG_959842/2009...5283_kdx3-2.jpg Conclusion, can you guys change this little mistake and upload it as a next official database please?

Wielingen, id.2048 Max speed: 25 to 28 Flags: Stabilizer to Stabilizer (Dual) Sensors: SQS-505, id.47196, replaced by SQS-510, id.47231 no ref. mentioning a Raytheon radar, id.43016 rather, a Scout radar, id. 43376 and a Type 1007, id.43069 are mentioned for SS surv. Mounts: The Mk 29 NATO Sea Sparrow launcher, id.59675 have been upgraded to fire Sea Sparrow RIM-7P, id.18692, rather than Sea Sparrow RIM-7M, id.18442. Isn't the case for all ships fitted with this launcher? MM.38 Exocet Twin Fwd, id. 59802, a little detail, in fact the two cover each a different sector (9h/11h and 1h/3h), they aren't able to fire 12h. Torpedo Tubes 324mm TT w/…

I was looking at the Strategic Defense Intelligence site and came across these three articles: http://www.strategicdefenceintelligence.co...hvi_II_missile/ This one appears to just be a range increase over the one already in the DB. http://www.strategicdefenceintelligence.co...dified_cockpit/ This appears to be a typo (helicopter?) but I did some more research and I believe its about this aircraft: http://www.globalsecurity.org/military/world/india/lca.htm I looked in the in game platform display but didn't see it in there. And last: http://www.strategicdefenceintelligence.co...vladimir_putin/ Not a very informative article but an intersting platform IMO…

The ASRAAM (Advanced Short Range Air-to-Air Missile), also known in US as the AIM-132, is a highly maneuverable heat-seeking short-range air-to-air missile produced by the United Kingdom’s MBDA corporation. It was developed in order to replace the aging AIM-9 Sidewinder. The ASRAAM entered service in 1998 and has since been deployed in at least one conflict. The ASRAAM’s effective 10 kg high-explosive fragmentation warhead can be triggered by either a proximity fuse or impact. It has a longer range and more powerful warhead than the US Sidewinder missile. It can be used on the F/A-18, Eurofighter, Typhoon, F-35. The ASRAAM can be used on any aircraft that can a…

With the addition of Westpac, a recreation of WWII in the Pacific would be on my wish list for HCE. What are the obstacles in creating a new database using Japanese, British and American platforms and loadouts? Is it even possible to do? Your comments, please. Regards, Terry

Hope it helps, Jan

I would like to know how to change or add a picture to a unit file. I would love to add realistic jpg's to my units. Is this possible? Somebody please tell me how. Thanks Keith

Hello, I sent Tony a WestPac scenario I designed three years ago and following my own ideas concerning the problem. I think I finally managed to come close to the solution. Yesterday I experienced several crashes - outside the WestPac battleset. It was time to deinstall and reinstall. I installed the original HC 2002 Gold and patches up to 2003.16b8 (Jan 17th, 2005). Now all scenarios, including my WestPac scen Duel run just fine. Thus my whole HC Gold installation probably was corrupt. Next I installed the latest HCDB, but now i get crashes in scenedit again when I try to edit groups/bases - "...probably corrupt rsr - file." My questions: 1. Is that …

Is there a Battleset and database available anywhere for Classic 2002 - World War II? Thanks Keith

I've been looking at the HCDB and specificly at the magazine/turret relationship of the Iowa BBs. On the turrets I notice that they each hold enough rounds that when combined with the magazines which hold 255 rounds, you have the total needed for each turret. Here's where I have a problem with that. If I remember correctly the magazines supply ALL the mounts of the same type. In other words, even if the front two turrets are blown up, the ship will continue to use the ammo supplied by all three magazines. That being said, I find it hard to believe you're going to be running 2700lb shells from one end of the boat to the other. Wouldn't it make more sense to place…