I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Web Stuff Topic   Print This     

Paradox 9 duplicates files when published to HTML

Paradox 9 duplicates files when published to HTML in Paradox Web Stuff topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   duplicates   published   Paradox 9   Paradox 9 duplicates   files when   published HTML  
Mookers
 (Inactive)
-- USA
Hi all, this is my first database in the working world. I just finishsed college and got this job. Big Grin! I have made a database with 63 entries todate, more will be added. I need to make this database accessible from the internet so clients may search it for items. I have not yet figured out the search stuff for the net or how to get the database online, but those are other issues I'll deal with later. Right now my problem is that when I select the table I want to make into a web page it duplicates all the JPG photos I have in the database and then just places them where ever it wants in the Generated HTML File. It's important for the pictures to stay where i need them because this is a database of books for sale. Each of the 63 entries has a picture and they are set to Graphic. When I run the Publish to html table expert it makes the web page but when it's done I have 98 JPG Files generated. As I add more records the number of generated JPG files duplicates further.

Btw, i have a fresh paradox 9 install with no patches of any kind.

Any Help from anyone would be appreciated greatly as i am getting closer to my September Deadline.

Thanks
Mookers
 Posted 15 years ago (Thread Starter)
Comment Quote
About Mookers -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
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 #10612, 4 replies
Thread Started 8/3/2004 8:36:00 AM
View Counter=3848
Last Reply Posted 8/7/2004 1:39:00 PM)
Location=-- USA 
Joined=15 years ago   MB Posts=2  
Steve Caple
Steve Caple Company
Sacramento, CA
< this is a database of books for sale. Each of the 63 entries has a picture and they are set to Graphic. When I run the Publish to html table expert it makes the web page but when it's done I have 98 JPG Files generated. >

Mookers, I'm not a web type, but I've done some work with Paradox and graphics files in the past. The first rule, as far as I'm concerned, is never store the graphic in the table. Instead store the path and file name. When you need to create a report table, then you can pull the images into Graphic fields in a temporary table for on-screen ir printed viewing. In Paradox, and as I understand it in other PC databases like Access and Approach, the graphic is first converted to a .BMP - this tends to make the stored image,and the table it is stored in, MUCH larger. There are possibly other problems of stability due to the huge record size.

The basic approach is to use the path and filename info (might be in one field, or paths might be stored in a different table for different categories of images) to do a readFromFile to a graphic type variable: e.g., gPhoto.readFromFile(stGFileSpec)

Then set the graphic field in the temporary table to the value in the graphic variable: e.g., tcCATALOG.setFieldValue("Photo", gPhoto)


Granted, this is not what you need to do. You need to learn how to use textStream methods to write a combination of HTML tags and variable information from your database, including graphic file references, to a text file with an HTM extension. What I've seen of this process used a number of different custom library methods to take parameters passed to the methods and/or data extracted from a tCursor being scanned and build the page header, table header, each line of the table, and the table and page footers, etc.

I have seen this used in a web catalog application using the Paradox web server OCX, to select real estate properties. Based on user selected postal codes, price ranges, etc., the application used first setRange(), and then if necessary setGenFilter() to further restrict the view of the tCursor already narrowed by the setRange operation (setRange is verry fast, operating only with indexes); then a scan loop through the remaining view built the HTML pages complete with data tables - all virtually instantaneously, and on an old PII/266 the first time I saw it.

If you need more than a pointer in the right direction, let me know, and maybe I can post some cites to other web discussions or someone else will chime in. You might start by using Google Advanced Groups Search (group setting "*paradox*) for the keywords you think appropriate.

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

 Posted 15 years ago
Comment Quote
About Steve Caple -Collapse +Expand
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 #10635 (Level 1.1)  Reply to 10612
Thread Started 8/5/2004 1:04:00 PM
View Counter=2
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Steve Caple
Steve Caple Company
Sacramento, CA
PS: the Publish to HTML function never worked satisfactorily to my way of thinking - the results were pretty ugly when they worked at all. Using tCursors and textStream to write the HTML is the only practical way to my knowledge.

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

 Posted 15 years ago
Comment Quote
About Steve Caple -Collapse +Expand
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 #10636 (Level 1.2)  Reply to 10612
Reply Posted 8/5/2004 1:07:00 PM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Most Recent Post
Steve Caple
Steve Caple Company
Sacramento, CA
You've already found the pnews site - if you have access to internet newsgroups rather than the web, the text-only newsgroups are much faster.

Check out the Corel Paradox FAQ newsgroup item on variable naming standards - start early, and your code will be more readable to yourself and to others, and save a lot of time on simple "housekeeping" questions. The Prestwood Coding Convention is one such compilation of variable, method and object naming practices if you want to look at that here. It's pretty close to what I developed in my own use, and not far from Mike Irwin's suggestions in the FAQ I mentioned, if a bit more rigorous and thorough-going. Or roll your own, but USE ONE - it'll become second nature and really benefit you, as well as others who try to help you wth your code.

If you do get newsgroup access, let me recommend 40tude Dialog (free to individual users) as a newsreader - over the years I've tried Netscape, Outlook (uggh!), Gravity, etc. - but Dialog takes the cake.

Keep on asking questions wherever - and check out Dennis Santoro's paradox pages at for more help and lots more links. Welcome aboard!

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

 Posted 15 years ago
Comment Quote
About Steve Caple -Collapse +Expand
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 #10644 (Level 1.3)  Reply to 10612
Reply Posted 8/7/2004 1:39:00 PM
Location=Sacramento, CA  
Joined=15 years ago   MB Posts=71   KB Posts=3  
Mookers
 (Inactive)
-- USA
Thanks for the reply Big Grin! I have been chatting with a few different people over at http://pnews.thedbcommunity.com/cgi-bin/dnewsweb.exe?utag=&group=pnews.paradox-web&xrelated=&cmd_latest=Latest+Items and from what I understand , well i don't understand all that much as i thought i did with Paradox. I do have alot of people helping me out and that's great. I also have the Paradox 9 Power Programming Book from Prestwood for referance. Unfortunately we never did study ObjectPAL in college so im at a loss there. I have been reading ALOT about objectPAL, almost to the point where my brain feels like mush, lol. I can code basic stuff like a query and opening a form for the query results instead of the default priv Answer table. I also managed to code for an edit button as well ^_^ . Outside of that basic stuff im a little lost, but slowly gaining knowledge everyday. Right now im reading alot about the TCursor, though i am having abit of troubles understanding some of it but im new at it, lol. For me the best way to learn is to have sample code like what I need and an explaination of what each line is doing. I think I would understand it then, lol. I know that can't happen though because no one knows what i really need ,lol.

Thanks again for the reply :)
 Posted 15 years ago (Thread Starter)
Comment Quote
About Mookers -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
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 #10643 (Level 1.4)  Reply to 10612
Reply Posted 8/6/2004 7:41:00 AM
Location=-- USA 
Joined=15 years ago   MB Posts=2  

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 = P1251A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #10612 Counter
3848
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech