Flash MX/Zinc - Syntax Error on SQL statement

[robtyketto]

Greetings,

When checking the syntax under flash mx it displays error (see below)

**Error** Scene=Scene 1, layer=AboutPage, frame=353:Line 10: ')' or ',' expected
mdm.Database.MSAccess.runQuery("INSERT INTO Results(Name,Results,ResultsDate) VALUES("Rob", 50,'"+Date()+'" )");

for the code below (Windows MDM Zinc 2.5):-

mdm.Database.MSAccess.runQuery("INSERT INTO Results(Name,Results,ResultsDate) VALUES("Rob", 50,'"+ Date() +'" )");

I didnt want to post without properly checking the code and also viewing other examples.

From what I can see all the brackets and quotes have matching partners and field name and values are correctly seperated.

Note: Name (string), Results (int) and ResultsDate (Date)

Can anyone spot the mistake?
Note: I also posted this on the MDMZinc forum too.


Thanks
Rob

[robtyketto]

I've resolved the syntax error.

' Single quotes for values.

Now just have to see if it works on runtime!