Discussion:
Move table to another DBC
(too old to reply)
John Dandy
2010-10-24 14:29:46 UTC
Permalink
Hello,

I need to move a table from one DBC to another, but without truncating
the long field names.

I've done his before, but so rarley that I never remember how to do it
again!

Thanks!

John
Paul Pedersen
2010-10-26 02:43:35 UTC
Permalink
Post by John Dandy
Hello,
I need to move a table from one DBC to another, but without truncating
the long field names.
I've done his before, but so rarley that I never remember how to do it
again!
Thanks!
John
If it can be done, that's a new one on me.

I would think that the best way to do it would be to read the table
structure in the old database, create a similar table in the new
database (use COPY STRUCTURE EXTENDED to make the job easier), then
append the data.
Dan Freeman
2010-10-26 03:21:33 UTC
Permalink
Post by Paul Pedersen
Post by John Dandy
Hello,
I need to move a table from one DBC to another, but without truncating
the long field names.
I've done his before, but so rarley that I never remember how to do it
again!
Thanks!
John
If it can be done, that's a new one on me.
I would think that the best way to do it would be to read the table structure
in the old database, create a similar table in the new database (use COPY
STRUCTURE EXTENDED to make the job easier), then append the data.
Probably easier to use AFIELDS() on the old table, then CREATE TABLE
FROM (Atray) in the new DBC.

Dan
Paul Pedersen
2010-10-26 03:40:31 UTC
Permalink
Post by Dan Freeman
Post by Paul Pedersen
Post by John Dandy
Hello,
I need to move a table from one DBC to another, but without truncating
the long field names.
I've done his before, but so rarley that I never remember how to do it
again!
Thanks!
John
If it can be done, that's a new one on me.
I would think that the best way to do it would be to read the table
structure in the old database, create a similar table in the new
database (use COPY STRUCTURE EXTENDED to make the job easier), then
append the data.
Probably easier to use AFIELDS() on the old table, then CREATE TABLE
FROM (Atray) in the new DBC.
Dan
Yes, that's probably better yet.
Tony Lance
2010-11-27 21:56:02 UTC
Permalink
Big Bertha Thing gyro
Cosmic Ray Series
Possible Real World System Constructs
http://www.bigberthathing.com/gyro.html
Access page JPG 12K Image
Astrophysics net ring Access site
Newsgroup Reviews including alt.war.nuclear

Drawing of an ordinary gyroscope.

Caption:-
Fig. XVI

Extract from the Introductory Chapter:-
But the most interesting top of all is undoubtedly the ordinary
gyroscope. That depicted in Fig. XVI........ although merely
sold as a toy, is nevertheless capable of illustrating
the gyroscopic phenomena which have been so much made use of in
modern mechanical invention.

From the book
An Elementary Treatment of the Theory of
Spinning Tops and Gyroscopic Motion.
By Harold Crabtree M.A.
Formerly Scholar of Pembroke College, Cambridge
Assistant Master at Charterhouse
Longmans, Green and Co. 1923
First Edition 1909
Second Edition 1914
New Impression 1923
(C) Copyright Tony Lance 1998
Distribute complete and free of charge to comply.


Big Bertha Thing rita

Educating Rita

This film portrays a dominant spouse and a long-suffering student,
to the extent upto and including divorce, book-burning and forced
pregnancy.

There was zero privacy. Any attempt to re-register or change
the password would not work, because the secret could not be kept.

Every posting by the spouse is a violation of OU rules and the
students
education, causing real pain. Vetting by one moderator or by several
using a non-public Rita conf. would not work, because the spouse
would use the students name, with all the further alienation
that would cause.

A new policy needs to be adopted. The last resort punishment measure,
needs to be the first resort measure on compassionate grounds;
that of making the student read-only on FC. The student would thank
you for it, but not publically.

It would need to be agreed between ACS and OUSA, which is what
they are there for.

Tony Lance
***@bigberthathing.com
+++++++++++++++++++++++++++++++++++++++++++++++++++
---------- Forwarded message ----------
From: "Dave Patrick" <***@nospam.gmail.com>
Date: May 8, 7:20 pm
Subject: RIP Tony Lance
To: microsoft.public.windowsnt.setup
---------- Forwarded message ----------
From: NT Guy <***@Guy.com>
Date: May 10, 1:40 pm
Subject: RIP Tony Lance
To: microsoft.public.windowsnt.setup
++++++++++++++++++++++++++++++++++++
Newsgroups: microsoft.public.windowsnt.setup
From: John John - MVP <***@nbnot.nb.ca>
Date: Sun, 14 Nov 2010 09:31:12 -0400
Local: Sun, Nov 14 2010 1:31 pm
Subject: Re: RIP Tony Lance
---------- Forwarded message ----------
From: "Paul Pedersen" <***@no.spam>
Date: Mar 23 2009, 10:56 pm
Subject: Windows Firewall blocking SQL Server
To: microsoft.public.sqlserver.server,
microsoft.public.windows.server.general


Thanks.

"Dave Patrick" <***@nospam.gmail.com> wrote in message
---------- Forwarded message ----------
From: "Paul Pedersen" <***@nospam.pacbell.net>
Date: Apr 3 2004, 9:44 pm
Subject: Problem with printing in VFP8
To: microsoft.public.fox.vfp.dbc
---------- Forwarded message ----------
From: ***@cs.cornell.edu (Paul Pedersen)
Date: Jul 2 1993, 8:26 pm
Subject: Solving quintics and higher
To: sci.math
---------- Forwarded message ----------
From: ***@acf4.NYU.EDU (paul pedersen)
Date: Apr 18 1990, 5:57 am
Subject: A brief survey.
To: sci.physics
+++++++++++++++++++++++++++++++++++++++++++++++++++
Bernhard Sander
2010-10-26 07:51:57 UTC
Permalink
Hi John,
Post by John Dandy
I need to move a table from one DBC to another, but without truncating
the long field names.
How about
OPEN DATABASE newdatabase
OPEN DATABASE olddatabase
SELECT * FROM olddatabase!sometable INTO TABLE sometable DATABASE newdatabase

Regards
Bernhard Sander
Dan Freeman
2010-10-27 06:22:41 UTC
Permalink
Post by Bernhard Sander
Hi John,
Post by John Dandy
I need to move a table from one DBC to another, but without truncating
the long field names.
How about
OPEN DATABASE newdatabase
OPEN DATABASE olddatabase
SELECT * FROM olddatabase!sometable INTO TABLE sometable DATABASE newdatabase
Regards
Bernhard Sander
Does that copy field defaults, captions, and other extended properties?

Dan
Bernhard Sander
2010-10-27 10:47:43 UTC
Permalink
Hi Dan,
Post by Dan Freeman
Post by Bernhard Sander
Post by John Dandy
I need to move a table from one DBC to another, but without truncating
the long field names.
How about
OPEN DATABASE newdatabase
OPEN DATABASE olddatabase
SELECT * FROM olddatabase!sometable INTO TABLE sometable DATABASE newdatabase
Regards
Bernhard Sander
Does that copy field defaults, captions, and other extended properties?
First I thought you got me.
But John did not ask for extended properties, only for long field names.
And I think, they are retained with SELECT.
So, as quite often in Foxpro: it depends...

Regards
Bernhard Sander
Continue reading on narkive:
Search results for 'Move table to another DBC' (Questions and Answers)
3
replies
Can you write a story with these phrases?
started 2007-08-09 16:46:33 UTC
words & wordplay
Loading...