How to insert multiple rows in Visual FoxPro?

Question

I'm using Visual FoxPro on my Classic ASP website, and I want to achieve the SQL syntax below to FoxPro version 6.

INSERT into users (id, name) 
VALUES 
(1, 'john'),
(2, 'kim'),
(3, 'jake')

But this syntax doesn't recognize by Visual FoxPro.

Answer 1

No version of Visual FoxPro supports that syntax for multiple row inserts. You will have to issue one insert statement per row.