Re: insert-sql a question
From: Anders Altberg (x_pragma_at_telia.com)
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.
"Vijay V. Nayak" <VijayVNayak@discussions.microsoft.com> wrote in message
> Hello Friends,
> The following syntax when triked in Visual Foxpro 6.0 is giving syntax
> 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.