9 2 LANSA Client

LANSA Client

9.2 LANSA Client

When you run a top ten style query, you get ten records, but not the top ten

For LANSA Client to perform a "top ten" query correctly, the records must be sorted on the host before the first 10 (or whatever number you have selected) are returned to the PC.

When you run a generated application, you are still asked to select the Host even though you specified a particular host for your application

This will occur if you change the LANSA Client environment and do not close and open LANSA Client before you generate the application. You will need to re-assign the host by opening the application, reselect the host and re-generating the application.

When retrieving a large volume of data, LANSA Client runs very slowly

You should always try to avoid retrieving large volumes of data. There are a number of reasons why this could occur. Most of them are unrelated to LANSA Client. First check that your query conforms to the recommendations in Performance Consideration and if you see no obvious reason for the query to run very slowly, contact your System Administrator.

You get a "General Protection Fault" message when attempting to use the Report command

You may have an incompatible version of Crystal Reports installed.

Data appears to be missing from the query you have executed

The Maximum Records Allowed option has been set in your LANSA Client environment to a lower number than you need for this query. This option is used to control the number of records transferred from the host. The same limit can also be set for this workstation using the Output Options in the Query menu.

You can either raise the limit by changing the Maximum Records Allowed or remove the limit altogether by changing it to zero.

The HotGraphing facility in LANSA Client does not work

HotGraphing may have been turned off in the Chart Options. If this is not the case, make sure that you are using the SPR3270.DLL in the LANSA Client directory. Delete any older versions you may have on your workstation.

An existing report does not appear to work any longer. When the report is executed, no data is displayed even though data was retrieved from the host

The type of data saved for the column headings of the report has been changed from field description to field label or vice versa.

Once the choice has been made to display either the field description or the field label, it should not be changed.

Please note that LANSA Client Version 1 used the labels as the column headings whereas, by default, later versions used the field descriptions.

Using the LANSA Client Administrator, change the column heading to use field labels, re-run the query again and save the data. Your existing report should now work.

When you run a prompted query, you cannot select the dropdown list or specify a value

Make sure that you are using the SPR32D70.DLL from the LANSA Client directory. Delete any older versions you may have on your workstation.

Further Information

Ý 9. Troubleshooting