Hi all, this is my first database in the working world. I just finishsed college and got this job. 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.
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.
< 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
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.
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
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.
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
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.
Thanks for the reply 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.
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.
Paradox
Print This
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. 
