>From Some Teaching Sql Syntax TextBook.
>I find some exampl '
>Insert Into Table_A ;
>Select column1,column2 ;
>from Table_B (where condition)
>
>I try this statment in vfp .
>I can run this statment.
>But I find It didn't insert any data into my Table_A.
>
>
>I also put '=TABLEUPDATE(.....Table_A)'
>It also useless..
VFP does not support the full ANSI SQL syntax for the INSERT command. Look up INSERT - SQL in VFP help (type "HELP INSERT - SQL" at the Command window, without the quotes).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up