CHAR(n) vs String vs int

Hi Guys,

I have noticed a funny inconsistency between lightspeed 2.2 and lighspeed 3, I am using an ORACLE database and the field type is CHAR(3).  When I drag and drop the table in lightspeed 2.2 it will set this property to be a string however in lightspeed 3 it will set the same property to be an int.

Can you please advise on why this is happening?

Josh

CHAR(3) should still be coming in as string.  We can't see anything that would be causing this behaviour.  Can you double-check that the column really is declared as CHAR(3)?  If so could you send us the CREATE TABLE statement please so we can try to reproduce it?  Thanks!

Yeah that's what i thought, the feild is definatly a char(3).  We have had a bunch of weird stuff happen, on the machines running LightSpeed 3; like we could not drag tables into the model, the model freezing Visual Studio.  Perhaps it is the install on the machine, is there a way of validating the install?

Hmm, that does sound like an unhappy install.  There's no real way of "validating" the install per se, but one thing you should do is check Control Panel and see if there are two "Mindscape LightSpeed" entries in there.  If so, you will definitely want to uninstall both of them (and then reinstall LightSpeed 3).  Also check the GAC to ensure that you don't have multiple versions of any Mindscape DLLs in there, and if you have anything left in the 2.2 install directory then you might want to clean that out just in case a rogue registry entry is resolving to the wrong place.

Also, have you had the VS2010 beta on these machines?  We've had reports of breakage after uninstalling VS2010, though the symptoms were different to yours.