MMF Crash

I have different crashes when i modify a specific event in the event-list editor. I can reproduce those easily. I think it's because the expression I modify is nearly "too complex".

Here is the expression after modification :
"SELECT R.Id,R.Nom, R.Faction, R.Coût, R.Skin, R.Description, R.Constitution, R.Force, R.Agilité, R.Intelligence, R.Dextérité, R.Plaine, R.Sable, R.Neige, R.Forêt, R.Eau, R.Eau_Profonde, R.Terre, R.Roc, R.Construction, R.Marais FROM Races AS R WHERE R.Nom='"+listGetAt$( "String Parser 2", 2)+"'"

I can provide the source code or any further explanation if this helps.
EDIT : The crash gives an error-message like "instruction at 0x7c 920f29 uses memory index 0x00000000. Memory cannot be read"

Is there a reason you're not using "*" for the select? You seem to have a vast amount of columns there - how many more are there?

Though i select most of the columns of this table, there are a few i don't need in this request. I could use "SELECT *" but one of the columns is some text which might be pretty long. Here's the whole list : Id Nom Faction Coût Niveauminimum Skin Description Constitution Force Agilité Intelligence Dextérité Plaine Sable Neige Forêt Eau Eau_Profonde Terre Roc Construction Marais

Anyway, MMF2 doesn't like my expression...

I actually misunderstood the problem at first, I thought the event was causing your application to crash. I'm not sure why that expression in particular would cause problems - I've had longer ones myself, and most of it is just a string that shouldn't cause problems. I'd be tempted to say it was the special characters doing it, but as MMF2 is originally French I would have thought that it would support them, so it's unlikely that's the problem either.

It would be interesting to see if selecting all the columns crashed also and I wonder if the crash could be related to String Parser 2?

Edit -- Ah I did a DavidN ... Its crashing in the event editor and not when you run MMF -- Most likely Yves or Francois would need to check it out then.

I can't say any more without you providing more details, but ensure you are using Build 244 of Multimedia Fusion.

I'm using last build.

Expressions using many " or ' or , seam to cause problem, I think I get "Expression too complex" errors more often when using such expressions.

Your expression is not that long, and it is only one string. Can you sedn me your application and tell me how to crash it?

I was able to reduce my app to a single event and still get the crash : http://www.clickteam.com/epicenter/ubbthreads.php?ubb=showflat&Number=42631&page=0#Po st42631