Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: John McLellan
  Where is John McLellan?
 Birmingham
 United Kingdom
 John McLellan
 Tags
Subject: RE: into database
Thread ID: 143384 Message ID: 143388 # Views: 1 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, August 28, 2007 1:59:32 PM         
   


> hi, has anyone come across 'into database' as part of a Select statement. The aim is to get the table created by the select statement directly into the current database.
>
> However i cant get it to work .
>
> Any suggestions?
>
> TIA
>
> John

select ... from ( ... ) ;
 into table ("c:\my database location\myNewTable") ;
 database ("c:\my database location\myDatabse.dbc")


Note that if you don't specify full paths you may end up with creating them at the wrong place or database.

Cetin Basoz

ENTIRE THREAD

into database Posted by John McLellan @ 8/28/2007 1:27:30 PM
RE: into database Posted by Ken Murphy @ 8/28/2007 1:48:59 PM
RE: into database Posted by John McLellan @ 8/28/2007 2:04:16 PM
RE: into database Posted by Ken Murphy @ 8/28/2007 2:05:59 PM
RE: into database Posted by Cetin Basoz @ 8/28/2007 1:59:32 PM
RE: into database Posted by John McLellan @ 8/28/2007 2:08:27 PM