RE: Print Table Structure

2013-02-18 Thread Rick Schummer
 Rick Schummer turned me on to Versatools years ago and I use it for printing 
 file structures as well as locating text
in a project.  I use it constantly!

I don't recall the recommendation, but glad it helped you.

I use the tools in Data Explorer and Thor these days.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/00b301ce0e2f$83088af0$8919a0d0$@whitelightcomputing.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Print Table Structure

2013-02-16 Thread Djordjevic Srdjan
Hi There 

Printing table structure (actually all ables in database) is one of the
samples in RS Demo Project
www.report-sculptor.com
Whole code that makes this report is there so you can customize it way you
want.
See if it can be of any use to you. 

HTH
Sergio 

-Original Message-
From: John Weller [mailto:j...@johnweller.co.uk] 
Sent: Wednesday, February 06, 2013 7:01 PM
To: profox@leafe.com
Subject: RE: Print Table Structure

Thanks to all who replied.  I'm coming back to Fox after a couple of years
in retirement and have forgotten lots of the little things which made life
easier.  I've used DISPLAY  in the past but forgotten it.  I like your
program Gary and will use it as the output is better formatted than the
DISPLAY output - many thanks!

Regards

John

John Weller
01380 723235
07976 393631

 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
 Garry Bettle
 Sent: 06 February 2013 12:00
 To: profoxt...@leafe.com
 Subject: Re: Print Table Structure
 
 On Wed, 6 Feb 2013 09:57:46 -, John Weller wrote:
 
 
  Is there an easy way to print out a table structure?
 
  John Weller
  01380 723235
  07976 393631
 
 
 Hi John,
 
 Hope this message finds you well - roll on the weekend.
 
 Here's a wee prg, Struct.prg that I keep in my home() directory.
 If I need a hard copy, I use SET ALTERNATE ON (and TO) and pipe it to 
 a
text
 file for email\printing.
 
 * Struct.prg
 
 PARAMETERS tcFile
 
 IF VARTYPE( tcFile) = [C]
 tcFile = [] + FULLPATH( tcFile) + []
 IF USED( tcFile)
 SELECT tcFile
 ELSE
  SELECT 0
 USE tcFile
 ENDIF
 ELSE
 IF !USED()
 RETURN
 ENDIF
 ENDIF
 
 gnFieldcount = AFIELDS( gaMyArray)
 
 SCATTER TO laRec MEMO
 
 ? [Structure for table:] + PROPER( JUSTFNAME( DBF()))
 ? [Number of data records: ] + ALLTRIM( TRANSFORM( RECCOUNT(),
 [99,999,999]))
 ? [Date of last update:] + TRANSFORM( TTOD( FDATE( DBF(), 1)))
 ? [Code Page:  ] + TRANSFORM( CPDBF())
 ?
 
 lcDBF = PROPER( JUSTFNAME( DBF()))
 lcSubDir = PROPER( JUSTSTEM( LEFT( ALLTRIM( DBF()), LEN( ALLTRIM( 
 DBF()))
 - LEN( JUSTFNAME( DBF())) - 1)))
 
 ?  [Field  Field Name  Type Width  Dec  Example from ] +
 lcSubDir + [, ] + lcDBF + [, Record ] + ALLTRIM( TRANSFORM( RECNO(),
 [99,999,999]))
 ?  [-  --  ---  -  ---
---
 -]
 
 FOR nCount = 1 TO gnFieldcount
? PADL( TRANSFORM( nCount), 5) + [  ] + ;
 PADR( gaMyArray( nCount, 1), 14) + [  ] + ;
 PADR( GetFieldType( gaMyArray( nCount, 2)), 11) + [  ] + ;
  PADL( TRANSFORM( gaMyArray( nCount, 3)), 5) + [  ] + ;
  PADL( IIF( gaMyArray( nCount, 4) = 0, [], TRANSFORM( gaMyArray( 
 nCount, 4))), 3) + [  ] + ;
  PADR( TRANSFORM( laRec[ nCount]), 80) ENDFOR ?
 ? [** Total **] + SPACE( 25) + PADL( TRANSFORM( RECSIZE()), 5)
 
 FUNCTION GetFieldType
 LPARAMETERS tcInput
 RETURN ICASE( tcInput = [C], [Character], ;
   tcInput = [Y], [Currency], ;
   tcInput = [D], [Date], ;
   tcInput = [T], [DateTime], ;
   tcInput = [B], [Double], ;
   tcInput = [F], [Float], ;
   tcInput = [G], [General], ;
   tcInput = [I], [Integer], ;
   tcInput = [L], [Logical], ;
   tcInput = [M], [Memo], ;
   tcInput = [N], [Numeric], ;
   tcInput = [Q], [Varbinar], ;
   tcInput = [V], [Varchar], ;
   tcInput = [W], [Blob], [])
 
 Cheers,
 
 Garry
 
 
 --- StripMime Report -- processed MIME parts --- multipart/alternative
   text/plain (text body -- kept)
   text/html
 ---
 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/3F2DEFC709954ED9B5FAC6021FC5D2F8@metzgrp.local
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-10 Thread Ken Kixmoeller
Sidekick was one he'll of a useful little tool. Loved it.
On Feb 8, 2013 11:20 AM, AndyHC a...@hawthorncottage.com wrote:


 Yo! lets hear a little cheer for Clipper!
 I used to code it under DOS with Peter Norton's Sidekick set to switch
 between Norton Editor (for editing) and DOS (for compile/link) - I used
 right-shift + left-shift as the hotkey. Happy days!!!

   AndyD

 On 08/02/2013 22:29, Man-wai Chang wrote:

 Sorry, I mixed up Clipper and Foxpro... :)

 On Fri, Feb 8, 2013 at 8:33 PM, Allen pro...@gatwicksoftware.com wrote:

 Might be DBF(). Never heard of ADBF()



 __**_
 Post Messages to: ProFox@leafe.com
 Subscription Maintenance: 
 http://mail.leafe.com/mailman/**listinfo/profoxhttp://mail.leafe.com/mailman/listinfo/profox
 OT-free version of this list: http://mail.leafe.com/mailman/**
 listinfo/profoxtech http://mail.leafe.com/mailman/listinfo/profoxtech
 Searchable Archive: 
 http://leafe.com/archives/**search/profoxhttp://leafe.com/archives/search/profox
 This message: http://leafe.com/archives/**byMID/profox/511533DC.1040102@**
 hawthorncottage.comhttp://leafe.com/archives/byMID/profox/511533dc.1040...@hawthorncottage.com
 ** All postings, unless explicitly stated otherwise, are the opinions of
 the author, and do not constitute legal or medical advice. This statement
 is added to the messages for those lawyers who are too stupid to see the
 obvious.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAFyV=LnT6MEp5Dam0jaoxLFB==KsAKAoVqkxCB=4bknhbdf...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-09 Thread AndyHC
Harbour was pretty moribund for some years but does seem to have made 
progress recently.
It generates C as intercode. Perhaps it could be merged with Guineu and 
other projects to make something that would turn Fox / Clipper source 
into a choice of Fox intercode, C, compiled C, Java or .NET IL bg
Add pre-compiler pragmas for keyword or squiggly bracket (or white 
space!) delimiters for flow control, a choice of assignment/equality 
characters and you've got a universal language (dream on).


On 09/02/2013 14:45, Man-wai Chang wrote:

Used to use SK.EXE, but later I switched to QEdit.

Are you aware of the Harbour and xHarbour Project?
http://harbour-project.sourceforge.net/

On Sat, Feb 9, 2013 at 1:20 AM, AndyHC a...@hawthorncottage.com wrote:

Yo! lets hear a little cheer for Clipper!
I used to code it under DOS with Peter Norton's Sidekick set to switch
between Norton Editor (for editing) and DOS (for compile/link) - I used
right-shift + left-shift as the hotkey. Happy days!!!





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51174066.3020...@hawthorncottage.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Print Table Structure

2013-02-08 Thread John Weller
I'm familiar with AFIELDS() but have not come across ADBF() and can't find
any reference in the Help files.  Any more info?

John Weller
01380 723235
07976 393631

 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
 Man-wai Chang
 Sent: 08 February 2013 11:50
 To: profoxt...@leafe.com
 Subject: Re: Print Table Structure
 
 ADBF() and AFIELDS() are your friend, if you needed to do something
special.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/001d01ce05f7$2ee67800$8cb36800$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread Allen

Might be DBF(). Never heard of ADBF()
Al

-Original Message- 
From: John Weller 
Sent: Friday, February 8, 2013 1:24 PM 
To: profoxt...@leafe.com 
Subject: RE: Print Table Structure 


I'm familiar with AFIELDS() but have not come across ADBF() and can't find
any reference in the Help files.  Any more info?

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/398A76D90E284CD9856E92048CCBF624@gslredacer
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread Frank Cazabon

Man-wai probably meant ADATABASES()

Frank.

Frank Cazabon

On 08/02/2013 08:33 AM, Allen wrote:

Might be DBF(). Never heard of ADBF()
Al

-Original Message- From: John Weller Sent: Friday, February 8, 
2013 1:24 PM To: profoxt...@leafe.com Subject: RE: Print Table Structure
I'm familiar with AFIELDS() but have not come across ADBF() and can't 
find

any reference in the Help files.  Any more info?


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/511500ec.6080...@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread MB Software Solutions, LLC
Doug Hennig's SDT (Stonefield Database Toolkit) always had nice 
outputted reports for table structures.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5115223d.8070...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread Michael Savage
I've used the PDM, from Ed Leafe's download section of his web site. It 
does more than table structure. Finds screens, classes, etc.


You might want to check it out. I've used it for that, but also for my 
software's documentation. (For me.)


Mike

On 08/02/2013 11:05 AM, MB Software Solutions, LLC wrote:
Doug Hennig's SDT (Stonefield Database Toolkit) always had nice 
outputted reports for table structures.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/51152451.2020...@golden.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread AndyHC


Yo! lets hear a little cheer for Clipper!
I used to code it under DOS with Peter Norton's Sidekick set to switch 
between Norton Editor (for editing) and DOS (for compile/link) - I used 
right-shift + left-shift as the hotkey. Happy days!!!


  AndyD

On 08/02/2013 22:29, Man-wai Chang wrote:

Sorry, I mixed up Clipper and Foxpro... :)

On Fri, Feb 8, 2013 at 8:33 PM, Allen pro...@gatwicksoftware.com wrote:

Might be DBF(). Never heard of ADBF()



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/511533dc.1040...@hawthorncottage.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Print Table Structure

2013-02-08 Thread John Weller
I had an earlier version when I was working for my living and found it very
useful but can't justify the cost now I am retired and doing a bit of coding
for charities as a favour.

John Weller
01380 723235
07976 393631


 
 Doug Hennig's SDT (Stonefield Database Toolkit) always had nice outputted
 reports for table structures.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/003701ce0621$6dd7f500$4987df00$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-08 Thread MB Software Solutions, LLC

On 2/8/2013 12:26 PM, John Weller wrote:

I had an earlier version when I was working for my living and found it very
useful but can't justify the cost now I am retired and doing a bit of coding
for charities as a favour.



Well I wouldn't buy it for the print outs alone, but for managing table 
structure/index/changes/repair it's worth the few hundred bucks.  Ask 
your charities for a small donation!




--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51154cee.1010...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-06 Thread Peter Cushing

In fox, open the table and type
display structure to print

You can also put TO FILE myfile.txt

* Peter Cushing *
IT development and support

Signature


John Weller wrote:

Is there an easy way to print out a table structure?

John Weller
01380 723235
07976 393631




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51122aa7.6020...@whisperingsmith.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-06 Thread Allen

There is a display structure to printer. Not tried it though
Al

-Original Message- 
From: John Weller 
Sent: Wednesday, February 6, 2013 10:57 AM 
To: profoxt...@leafe.com 
Subject: Print Table Structure 


Is there an easy way to print out a table structure?

John Weller
01380 723235
07976 393631


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/7629BF36843144398D83289146E0B3C0@gslredacer
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-06 Thread Andrew Stirling

in the downloads:
http://leafe.com/dls/vfp
there is dstructv.zip

Table Layout


Kind regards

Andrew Stirling
01250 874580
supp...@calcpay.co.uk
http://www.calcpay.co.uk
HMRC Accredited since 12/01/2004

On 06/02/2013 09:57, John Weller wrote:

Is there an easy way to print out a table structure?

John Weller
01380 723235
07976 393631




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/5112315c.8020...@calcpay.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-06 Thread Jean MAURICE

For the table structure :

SELECT matable
LIST STRUCTURE TO PRINTER  or TO FILE matable.str

For indexes :
LIST STATUS TO FILE matable.sta

HTH
The Foxil


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5112316e.9070...@wanadoo.fr
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Print Table Structure

2013-02-06 Thread John Weller
Thanks to all who replied.  I'm coming back to Fox after a couple of years
in retirement and have forgotten lots of the little things which made life
easier.  I've used DISPLAY  in the past but forgotten it.  I like your
program Gary and will use it as the output is better formatted than the
DISPLAY output - many thanks!

Regards

John

John Weller
01380 723235
07976 393631

 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
 Garry Bettle
 Sent: 06 February 2013 12:00
 To: profoxt...@leafe.com
 Subject: Re: Print Table Structure
 
 On Wed, 6 Feb 2013 09:57:46 -, John Weller wrote:
 
 
  Is there an easy way to print out a table structure?
 
  John Weller
  01380 723235
  07976 393631
 
 
 Hi John,
 
 Hope this message finds you well - roll on the weekend.
 
 Here's a wee prg, Struct.prg that I keep in my home() directory.
 If I need a hard copy, I use SET ALTERNATE ON (and TO) and pipe it to a
text
 file for email\printing.
 
 * Struct.prg
 
 PARAMETERS tcFile
 
 IF VARTYPE( tcFile) = [C]
 tcFile = [] + FULLPATH( tcFile) + []
 IF USED( tcFile)
 SELECT tcFile
 ELSE
  SELECT 0
 USE tcFile
 ENDIF
 ELSE
 IF !USED()
 RETURN
 ENDIF
 ENDIF
 
 gnFieldcount = AFIELDS( gaMyArray)
 
 SCATTER TO laRec MEMO
 
 ? [Structure for table:] + PROPER( JUSTFNAME( DBF()))
 ? [Number of data records: ] + ALLTRIM( TRANSFORM( RECCOUNT(),
 [99,999,999]))
 ? [Date of last update:] + TRANSFORM( TTOD( FDATE( DBF(), 1)))
 ? [Code Page:  ] + TRANSFORM( CPDBF())
 ?
 
 lcDBF = PROPER( JUSTFNAME( DBF()))
 lcSubDir = PROPER( JUSTSTEM( LEFT( ALLTRIM( DBF()), LEN( ALLTRIM( DBF()))
 - LEN( JUSTFNAME( DBF())) - 1)))
 
 ?  [Field  Field Name  Type Width  Dec  Example from ] +
 lcSubDir + [, ] + lcDBF + [, Record ] + ALLTRIM( TRANSFORM( RECNO(),
 [99,999,999]))
 ?  [-  --  ---  -  ---
---
 -]
 
 FOR nCount = 1 TO gnFieldcount
? PADL( TRANSFORM( nCount), 5) + [  ] + ;
 PADR( gaMyArray( nCount, 1), 14) + [  ] + ;
 PADR( GetFieldType( gaMyArray( nCount, 2)), 11) + [  ] + ;
  PADL( TRANSFORM( gaMyArray( nCount, 3)), 5) + [  ] + ;
  PADL( IIF( gaMyArray( nCount, 4) = 0, [], TRANSFORM( gaMyArray(
 nCount, 4))), 3) + [  ] + ;
  PADR( TRANSFORM( laRec[ nCount]), 80) ENDFOR ?
 ? [** Total **] + SPACE( 25) + PADL( TRANSFORM( RECSIZE()), 5)
 
 FUNCTION GetFieldType
 LPARAMETERS tcInput
 RETURN ICASE( tcInput = [C], [Character], ;
   tcInput = [Y], [Currency], ;
   tcInput = [D], [Date], ;
   tcInput = [T], [DateTime], ;
   tcInput = [B], [Double], ;
   tcInput = [F], [Float], ;
   tcInput = [G], [General], ;
   tcInput = [I], [Integer], ;
   tcInput = [L], [Logical], ;
   tcInput = [M], [Memo], ;
   tcInput = [N], [Numeric], ;
   tcInput = [Q], [Varbinar], ;
   tcInput = [V], [Varchar], ;
   tcInput = [W], [Blob], [])
 
 Cheers,
 
 Garry
 
 
 --- StripMime Report -- processed MIME parts --- multipart/alternative
   text/plain (text body -- kept)
   text/html
 ---
 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/002601ce048b$82867c20$87937460$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Print Table Structure

2013-02-06 Thread Richard Kaye
If you do ever use DISPLAY or LIST  TO FILE for something, don't forget the 
NOCONSOLE keyword if you want to avoid having the output echoed to the screen.

--
rk


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller
Sent: Wednesday, February 06, 2013 12:01 PM
To: profoxt...@leafe.com
Subject: RE: Print Table Structure

Thanks to all who replied.  I'm coming back to Fox after a couple of years in 
retirement and have forgotten lots of the little things which made life easier. 
 I've used DISPLAY  in the past but forgotten it.  I like your program Gary 
and will use it as the output is better formatted than the DISPLAY output - 
many thanks!

Regards

John


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0442181D11BA2@ACKBWDDQH1.artfact.local
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Print Table Structure

2013-02-06 Thread Jeff Johnson
Rick Schummer turned me on to Versatools years ago and I use it for 
printing file structures as well as locating text in a project.  I use 
it constantly!


I can't find a link.  Maybe Rick can chime in here.


Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com
www.arelationshipmanager.com

On 02/06/2013 02:57 AM, John Weller wrote:

Is there an easy way to print out a table structure?

John Weller
01380 723235
07976 393631




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5112b2a0.4000...@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.