MMF Crash

[Corentin]

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"

[DavidN]

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?

[Corentin]

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...

[DavidN]

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.

[Jeff]

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.

[Joshtek]

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

[Corentin]

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.

[Francois]

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?

[Corentin]

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