Recent content by SonOfTed

I've used Paradox for simpler applications for about five years now. If I stick to basic child-parent table relations, lookups, basic forms and reports etc. it still works fine for me in Windows XP Professional networked environment. I do occasionally have users reporting "General Protection...

Before you modify the lookup table also be certain that all other open windows with forms or other objects referencing that table are closed... especially if they are in "Edit Mode" (F9)

2-03-2006: Additional update on report problems. Just to let everyone know, occasionally I still get "General Protection Violation" errors or other messages when running reports or modifying them in design mode. Another tip I have found to minimize this problem: 1. I used to use the "Report...

Tony's example: << Basics for a outer join is: << select columnanmes << from tableA a left outer join tableB b << on a.id=b.id << where conditions << Left can be replaced by Right or Full 1. What is the significance of the left, right, or Full parameter? 2. In the past I have only...

How would I place that in the "WHERE" clause of my sample SQL above? .. .. .. (D1.Child_ID = d.Child_ID) changed to (D1.Child_ID (+) = d.Child_ID (+)) or ((+) D1.Child_ID = (+) d.Child_ID) will not work. I need the "outer join" for both linked tables (Goals and Children).

Thank you very much! I shall try that!

Below is some SQL that I created and modified from a standard .QBE query by using the "View", "Show SQL" commands from the query window. SELECT d.Child_ID, D1."Date", d2.Goal_ID, d2."Hour", d2.Score, d."Last_Name"+", "+d."First_Name"+" - "+d.Child_ID as SName FROM "Children.db" d, "Goals.DB"...

Since Excel is a Microsoft application and Paradox is part of Word Perfect there are sometimes incompatibilities between the two. There are even problems occasionally between Paradox and Quattro Pro and they're part of the same software package! I sometimes use a two-step process when importing...

Some programming languages have a simple way to refer to special characters such as the apostrophe or a quote symbol. For example, if I am creating a text string with an apostrophe in it: TEXT = "Joe" + "'" + "s Pizza" = "Joes Pizza" Some applications don't understand the reference if the...

One of the employees I work with was running a Paradox report today and ran into an "Unexpected General Protection Error" when trying to print the report. It was only 16 pages in length. The flaw appears to be in the Paradox Report Object, not necessarily its filters. Although the employee does...

bayBell said: > Don’t store the filter with the report > base the report on the answer table That's one of the BETTER suggestions I've heard. I will keep this in mind when designing newer systems and enhancing old ones. I have been hesitant to start using too many "buttons" and "ObjectPal"...

Thanks for the info. I guess I don't plan to abandon filters altogether just yet. So far the following solutions have worked well for me: 1. Setting up a ONE row table with the row containing parameters that can be changed each month. The report object then references that row rather than...

Additional information: I was finally able to get the report to print by adjusting the fields on the Design screen so that the page break changed. Why should the screen preview and WHERE the page break occurs cause trouble? It was only a 2 page report... and not like the report generated was...

I have managed to create some VERY good systems in Paradox with the exception of reports whose filters change from month to month. 1. Report objects run fine as long as filters do not change from month to month and are stored with the report file. 2. As soon as the user has to open the report...

Q: What version of Paradox are you using? A: Version 11. Q: Single workstation, or shared data? A: Shared on a network drive. Q: If shared, is 'Local Share = True' set in the BDE Administrator? A: Mine was set to “False” ... will try it with “True” for awhile. Q: If shared, what OS on the...