| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| 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™.