SQL compact edition 3.5 insert multiple rows

[gerbrandc]

Hello,

how can I insert into the sql compact edition 3.5 multiple rows.
I have following query

INSERT INTO network (name, adname, timezone) VALUES
('rm', 'rm', 1),
('pm', pm', 1) ,
('PLURIELLES', 'PLURIELLES', 1),
('SPORTS', 'SPORTS', 1);

if I do this in the editor of the microsoft visual studio 2008 I get following error

'Unable to parse query text.'

Is this not possible to do in the compact edition? Or have I an error in my query?

thanks

[ck9663]

You have to issue an INSERT for each of those values.

-- CK