Printing/Exporting Structure of a Table

Printing/Exporting Structure of a Table

Post by LA » Thu, 16 Mar 1995 00:52:41



To All,

I cannot remember where I saw it, but I know that one can print/export the
fields of a PDOXWIN 4.5 table.  I've scanned the news, looked on line
at Borland (WWW), and checked back issues of _PDOX Informant_.  Did I dream
this capability up?

All help will be greatly appreciated.

LAA

---
############################################################################
# LAA                                                                      #
#                                                                          #
# Hooked on Phonics?  Just say NO.                                         #
#                                                                          #

#                               DISCLAIMER, DISCLAIMER, DISCLAIMER...      #
############################################################################

 
 
 

Printing/Exporting Structure of a Table

Post by KevinBlu » Thu, 16 Mar 1995 04:39:07


Quote:>I cannot remember where I saw it, but I know that one can print/export
the
>fields of a PDOXWIN 4.5 table.  I've scanned the news, looked on line
>at Borland (WWW), and checked back issues of _PDOX Informant_.  Did I
>dream this capability up?

No, you didn't dream it up. It WAS in this last issue of Informant (March
'95), on page 65.

Yes, it's possible, but it isn't simple.

Use File | Utilities | Info Structure to display that Info dialog for the
table in question. Close the dialog. Unbeknownst to most people, Paradox
has produced a temporary table called :PRIV:STRUCT.DB. Go ahead and open
that table. You may now export or report on it like any other table.  You
probably just want to generate a Quick Report with Shift-F7.

You'll find, though, that most of the fields are useless computerese for
your purposes. You may want to develop a permanent report that only shows
the fields you want to see from the Struct table.

Kevin J. Bluck


 
 
 

Printing/Exporting Structure of a Table

Post by Nigel Rhe » Fri, 17 Mar 1995 09:50:43



Quote:> I cannot remember where I saw it, but I know that one can print/export the
> fields of a PDOXWIN 4.5 table.  I've scanned the news, looked on line
> at Borland (WWW), and checked back issues of _PDOX Informant_.  Did I dream
> this capability up?

Do an 'Info Structure' or 'Restructure' on the table and, IIRC, the table
definition gets chucked into a table; :PRIV:STRUCT.DB
Query and / or report on that. There are a few slightly cryptic columns
(l0okup_type?), but on the whole it's pretty straight-forward.
There's also a Table method enumFieldStruct which does the same, but to
a table of your choice.

Have fun!

--
Nij

 
 
 

Printing/Exporting Structure of a Table

Post by Kuo-Sheng (Kas » Fri, 17 Mar 1995 23:00:45


: I cannot remember where I saw it, but I know that one can print/export the
: fields of a PDOXWIN 4.5 table.  I've scanned the news, looked on line
: at Borland (WWW), and checked back issues of _PDOX Informant_.  Did I dream
: this capability up?

4.5 or 5.0?

4.5 : Info structure the table will generate a STRUCT.DB in your :PRIV:,
which you can then view and do Quick Report on

5.0 : Info structure the table will show a SAVE AS... button which you
can save as :PRIV:STRUCT.DB (or whatever) which you can view and do Quick
Report on.

--
+==========================================================================+

| Pretty good Paradox for Windows Programmer, self-proclaimed Treknologist |
|--------------------------------------------------------------------------|
| Editor of XCOM: The UN-official Strategy Guide  Latest update Feb 1st,95 |
|  get it at Game Domain==> ftp://wcl-l.bham.ac.uk/pub/djh/faqs/x-com.faq  |
+==========================================================================+

 
 
 

1. Exporting table structures

Hi,
I'm developing a web site based on a database at my client's firm which is a
production server and full of live data. The work Im doing is offsite on my
machine which has no network connection to my client's database. Some of the
development Im doing has meant altering exisitng tables (generally adding
columns). Can someone tell me the best way of me transfering new table
structures to my client's place, updating their server and NOT deleting the
exisiting data? At the moment I create a backup database on their box,
generate scripts of my tables and SPs with drops in, run them against their
database and then import the data back in.
Is there a better way? What I really need is something that can compare the
two databases and generate a script which does a series of ALTER TABLE or
CREATE TABLE s as necessary.

Ian Lawton

2. Difference DAO /ADO

3. Exporting Table Structures?

4. fsync and -F option

5. Exporting table structure in XML.

6. Sr. Programmer/Analyst

7. Is there a way to export an .MDB table structure to SQL create statments

8. Warehouse company looking for new database system

9. Exporting a MS Access table (structure and data) using ADO to text file

10. How to print off Table Structures in MS SQL 6.0

11. Printing the table Structure

12. How to print all stored procedures/table structures

13. Print Table Structure