Re: insert-sql a question

From: Anders Altberg (x_pragma_at_telia.com)
Date: 10/08/04


Date: Fri, 8 Oct 2004 14:49:47 +0200

You're using VFP6. INSERT INTO .. SELECT FROM was only introduced in VFP8.
You can download a free beta version of VFP9 from http://msdn.com/vfoxpro.
The beta version will be valid till March 2005.
-Anders

"Vijay V. Nayak" <VijayVNayak@discussions.microsoft.com> wrote in message
news:A90F0DAB-5ABD-4FE9-ADA2-C38CDF3CBD63@microsoft.com...
> Hello Friends,
>
> The following syntax when triked in Visual Foxpro 6.0 is giving syntax
error.
> What is the correct one ?
> Does this method of sql-insert works in VFP 6.0 ?
>
> insert into table1 ( field1, field2, ...) ;
> Select field1, filed2, ... from table2
>
> I request the valuable comments. Thanks,
>
> Vijay Nayak.