>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?
Both are allowed in the VALUE clause, with some things to remember:
(1) table values - you can only 'see' and reference tables/cursors/aliases in use in the current datasession. If the reference is open in another datasession but not this one, it will smoke.
(2) object values - the object reference must be in scope and correct - this and thisform can be dangerous if you aren't in a place where the object reference is in sight (like in another form, or in a class instance inside a form!) or the object reference is not in scope (ie a LOCAL value defined outside the current procedure/method and not passed down to it.)
(3) if an object MyRef has a property MyProp, and you have a table/cursor view referenced by the alias MyRef with a field MyProp, VFP will probably get confused resolving MyRef.MyProp