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


> >
> > John,
> >
> > You SELECT INTO a table rather than a database. Think about it, the natural result of a SELECT is a cursor (read "temporary table") and therefore the structure is that of a table. You can of course add the DATABASE clause as a modifier:
> >
> >
> > SELECT ... INTO TABLE MyTable DATABASE MyDatabase NAME MyLongTableName
> > 

> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)
>
>
>
> Thats exactly what i was after ,thanks
>
> John

John,

You are most welcome. Take a look at Cetin's reply - especially his note about specifying the exact path. While you can use relative paths, you have to be careful when doing so.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

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