-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Forms Topic   Print This     

memo fields

memo fields in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: memo fields  
William Swain
Ultra Electronics
 (Inactive)
Alexandria, VA
Can anybody help with extracting memo field information in preperation to exp[ort to Excel.

I ran a structured query using several tables and got my answer. Included are several memo fields that detail out findings, conclusions, etc. for a record. However, our analysts does not use paradox and needs the data in Excel.

I am aware that an Excel cell will most likely trim the memo field to say 256, but thats OK.

I prefer to not use object code as our system is locked down to prevent data corruption with spurious code. Mike P., I am sure you are aware of our data issues working with Dan.

Regards,
Bill
 Posted 22 years ago (Thread Starter)
Comment Quote
About William Swain
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #10834, 1 replies
Thread Started 11/17/2004 1:32:00 PM
View Counter=2008
Last Reply Posted 11/22/2004 12:49:00 PM)
Location=Alexandria, VA  
Joined=24 years ago   MB Posts=10  
Most Recent Post
Steve Caple
Steve Caple Company
Sacramento, CA
If it's really OK that the memo be trimmed to a 256 character string, you could create a table with the same key field[s] as the one you want to export plus an A255 field (let's call it EXPMEMO.DB and the field ExpMemo). Open tCursors on both tables - tcMain and tcExp; place tcExp in edit mode.

Then do a tCursor scan through the main table, and at each record insert a record in tcExp,
assign the key values from tcMain, cast the memo value from tcMain as a string, take the substr(1,255) of that string, and asssign THAT to tcEx."ExpMemo".

Now run a query to join the two tables, leaving out the memo field and including the ExpMemo field. Export the query result to Excel.

Just crude and off the top of the head, but it ought to work. And if the export candidate is able to fit in Excel, it can't be too time consuming.

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 22 years ago
Comment Quote
About Steve Caple
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #10846 (Level 1.1)  Reply to 10834
Thread Started 11/22/2004 12:49:00 PM
View Counter=2
Location=Sacramento, CA  
Joined=22 years ago   MB Posts=71   KB Posts=3  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1141A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #10834 Counter
2008
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]