Search results for query: *

We had an earlier question regarding printing reports, and we came up with the following solution. We added a routine to the library (the code follows), and a small form with a Print button and a Close Button. The code is given below. To overcome the dialog error box problem, we added the...

I found the problem. Enough said.

I have a date field on a form in which the operator enters a date. When I try to use that date in a due date calculation on the save button on the form, I get the "unassigned variable" error. If I put a msginfo command in the depart event of the field, the date shows up. If I put the same...

In chasing this problem on another website, I came across the following comments. It agrees with my experience in that if I select 800 by 600 for my display, the cursor behaves properly. Programmer 1: This is a known problem in P10 when using at least ZoomBestFit, perhaps other...

When we went from V 10 to V 11, we found our cursor moves ahead of the text. With a remarks field of 250 characters, the cursor leads the text by several character widths before the end of the first line. The real problem occurs when you want to delete a character; until you practice a lot...

To overcome the dialog error box problem, we added the following function to lib1. Library Routine: method OpenReport(orient String,rptName String) var repinfo ReportPrintInfo prnOptions PrinterOptionInfo tc tCursor strReportName String ;// tmp handle to report name rHandle Report...

We seem to have solved the problem. We added Print and Cancel buttons on the report, and we don't get the error. I had hoped to post a reply here with the ObjectPAL code, but I haven't been able to get it. We moved buildings, and the individual who has the code is bogged down getting the...

Lance, Resaving did not help. The reports all have the default style sheet. I built a new report, assigned a style sheet, and received the same error when I went to print. I have copied the error displayed: "Report layout settings (page size, paper orientation) have been changed...

We have a number of reports that have run in every version of Paradox up to version 11. In version 11, we are told the paper format is incorrect, and the report will be reconfigured. The warning includes a line that this could take some time. Once we click the OK button, the report comes out...

Hans and Lance, I can now identify the potential records of interest in about 10 seconds; a vast improvement over the SQL. Yes, I need to do it in two steps. The initial query from Hans will build my list of potential serial numbers, and I can add the other requirements in a second query...

I have a table with legitimate and illegitimate records. I want to run a query based on one field, serial_number, that will show the serial number and a count of the records of interest. The following SQL works, but it takes several minutes. SELECT DISTINCT sn, count(*) FROM...

Hans, Thank you. Your suggestion works fine. Ernie

I have two tables that should have the same records. However, that is not the case. The common field is part_SN. I should like to run a query that selects the records from table 1 that are not in table 2. I built a SQL statement, but it is incredible slow. TIA, Ernie