TIP: Click on subject to list as thread! ANSI
echo: paradox
to: JAN HOOLWERF
from: KEN THOMPSON
date: 1995-06-15 15:41:00
subject: Pdox45 moving data to new table

Jan Hoolwerf wrote in a message to Ken Thompson:
 KT>    I am pretty new to Paradox so please bear with me.
 JH> Although i use PDox since three years and made some small
 JH> applications for collegues at the office i still consider
 JH> myself as a novice but, and that is very important, i always
 JH> got meaningfull answers from those here that really *know*
 JH> PDox. That's the nice thing of this echo.
   I appreciate the response, believe me!  I'm no idiot, but this is new and 
requires a little helpful guidance.
 KT> 1) How do I copy selected fields from one table to a newly
 KT> created table?  I want to do this so that I may split my original
 KT> table into three tables.
 JH> 1) create a query and select the fields you need and rename
 JH> the answer table and do yhis three times and you're ready.
   Now this is an intersting way to do it!
 JH> 2) copy the original table to the three new ones and modify
 JH> the structure of each new table: just delete the fields you
 JH> don't need.
   This is what I was trying to do originally, but I thought I was brute 
forcing it this way.
 KT> 2) I have an alphanumeric field that I want to convert to a memo
 KT> field.  When I do this, it crashes Paradox when I attempt to
 KT> restructure the table the next time.
 JH> Mmm... i have done this once and had no problems. Use
 JH> TUTILITY on the new table to see if it's OK. That's all i
 JH> can come up with.
   Hmmm, well I'll give it a go.  Is Tutility like Dsalvage?
                                   ^^^^^^^^^ Way out there!
Ken T. 
--- timEd-B11
---------------
JH> * Origin: The Fractal Lover (2:283/211)
* Origin: Linear Logic BBS * Houston, TX (1:106/7667)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.