Re: CRS and Generating a Data Dictionary.

2021-03-10 Thread MB Software Solutions, LLC
That's it...knew I heard that right.  Thanks for the links, Ted! On 3/10/2021 3:47 PM, Ted Roche wrote: https://doughennig.blogspot.com/2020/01/stonefield-database-toolkit-is-now-open.html https://github.com/DougHennig/StonefieldDatabaseToolkit On Wed, Mar 10, 2021 at 3:38 PM Vince Teachout

Re: CRS and Generating a Data Dictionary.

2021-03-10 Thread Ted Roche
https://doughennig.blogspot.com/2020/01/stonefield-database-toolkit-is-now-open.html https://github.com/DougHennig/StonefieldDatabaseToolkit On Wed, Mar 10, 2021 at 3:38 PM Vince Teachout wrote: > On 03/10/21 11:37 AM, Vince Teachout wrote: > > I seem to recall that there was some built in way

Re: CRS and Generating a Data Dictionary.

2021-03-10 Thread Vince Teachout
On 03/10/21 11:37 AM, Vince Teachout wrote: I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am blanking out. Anybody recall this? Thanks, all!  I'll look to see if I still have SDT, but if not, I do recall having looped through ATables

Re: CRS and Generating a Data Dictionary.

2021-03-10 Thread Ted Roche
SDT is the better way to go, but you could just loop through ADatabases(), ADBObjects() or AFiles() for free tables and then use AFIELD(). Or DISPLAY STRUCTURE and parse the result, but that would be wrong. https://hackfox.github.io/section4/s4g666.html https://hackfox.github.io/section4/s4g284.ht

RE: CRS and Generating a Data Dictionary.

2021-03-10 Thread Richard Kaye
SDT would definitely be a better choice if you have a copy handy, Vince. -- rk -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Wednesday, March 10, 2021 11:47 AM To: profoxt...@leafe.com Subject: Re: CRS and Generating a Data Dictionary. Also, iirc, S

Re: CRS and Generating a Data Dictionary.

2021-03-10 Thread MB Software Solutions, LLC
Also, iirc, Stonefield Database Toolkit was made open source awhile back.  Even at cost, it's super worth it.  Provides great documentation too.  I work with VFP databases with one client and it makes database management so much easier than without it. On 3/10/2021 11:44 AM, Richard Kaye wrote

RE: CRS and Generating a Data Dictionary.

2021-03-10 Thread Richard Kaye
IRCC VFP has a wizard for that. -- rk -Original Message- From: ProfoxTech On Behalf Of Vince Teachout Sent: Wednesday, March 10, 2021 11:38 AM To: profoxt...@leafe.com Subject: CRS and Generating a Data Dictionary. My brain doesn't want to work, and I don't want to end up re-inventing

CRS and Generating a Data Dictionary.

2021-03-10 Thread Vince Teachout
My brain doesn't want to work, and I don't want to end up re-inventing the wheel. I need to generate a basic data dictionary for a database -tables, fieldnames, data type and length. I seem to recall that there was some built in way (or sample tool) that came with VFP that did this, but am b