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



Thanks for the advice Cetin

John

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