>I'm new to VFP and am attempting to utilize the SQL INSERT INTO command but the help files provide minimal information. Is it possible to use table values or object values in the WITH clause? When I tried this I got a SYNTAX error. Is there something else I'm missing?
Like there's no WITH clause in INSERT INTO?
INSERT INTO <i>table name</i> ;
(<i>field list</i>) ;
VALUES (<i>value list</i>)