Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Giuliano Pigozzi
  Where is Giuliano Pigozzi?
 verona
 Italy
 Giuliano Pigozzi
 Tags
Subject: RE: Insert () Select problem
Thread ID: 49938 Message ID: 53562 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, October 14, 2004 11:43:25 AM         
   


Hi Graham

> > Only in Version 9.0.

Whoops! Correction, it was first introduced in Version 7.0, but could not handle sub-queries or virtual tables in the construct. These extensions were introduced in VFP 9.0

> it's a amazing bug.........

Why amazing and certainly not a bug.

The construct is not part of the ANSI 92 SQL standard is it? I thought it was an (optional) extension of the standard that was implemented by most, but not all SQL vendors.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA

ENTIRE THREAD

Insert () Select problem Posted by Graham Brown @ 8/26/2004 3:20:59 PM
RE: Insert () Select problem Posted by Yuri Rubinov @ 8/26/2004 3:28:45 PM
RE: Insert () Select problem Posted by Graham Brown @ 8/26/2004 3:39:41 PM
RE: Insert () Select problem Posted by Andy Kramek @ 8/26/2004 9:27:37 PM
RE: Insert () Select problem Posted by Giuliano Pigozzi @ 10/14/2004 11:23:47 AM
RE: Insert () Select problem Posted by Andy Kramek @ 10/14/2004 11:43:25 AM