Page 1 of 1

Bug: Missing delimeter in SQL Statement

Posted: Fri 28 Dec 2007 4:05 pm
by II./JG1_Krupinski
There is a unwanted feature in DCS 3.1.3.

In the screenshot listed below notice the missing field delimiter in the sql statement right before the AND,

... WHERE Obj_Group_Name = 'Kriegsmarine09 AND ...

http://www.fly-eaglesnest.com/downloads ... _error.JPG

This error occurres everytime I build a new mission.

Is there some work around I can try in 3.1.3? I dont want to go to 3.1.4 quite yet.

Best regards,

Raven

Posted: Sat 29 Dec 2007 7:05 am
by IV/JG7_4Shades
Yes, there is a broken SQL query right there in the Supply tracking code. It is missing a quotation mark ' right after Kriegsmarin09. No work around. The fuel update calculation for that unit will fail. I think that is fixed for 3.1.4. Hopefully it won't cause lasting problems for your 3.1.3 campaign.

Cheers,
4Shades

Posted: Sun 30 Dec 2007 12:01 am
by II./JG1_Krupinski
IV/JG7_4Shades wrote:Yes, there is a broken SQL query right there in the Supply tracking code. It is missing a quotation mark ' right after Kriegsmarin09. No work around. The fuel update calculation for that unit will fail. I think that is fixed for 3.1.4. Hopefully it won't cause lasting problems for your 3.1.3 campaign.

Cheers,
4Shades
Can I run the statement manually?

Posted: Sun 30 Dec 2007 6:17 am
by IV/JG7_4Shades
Yes, as long as you put the missing quote mark in.

As I recall, the broken query code lies in the Task Force update function.

Cheers,
4Shades