PC crash - Left Joins 1

[JonBartels]

Anybody have experience where a Left Join is causing the PC to either:
a) Crash (page fault)
or b) Hang indefinitely?
If so, how did you fix it?
Thanks for any suggestions.

 

[fluteplr]

what is your backend database ?

 

[JonBartels]

The datasource is an accounting package called MAS 90.

The dialog box reads:
CRW32 caused an exception 10H in module CRW32.EXE at 016f:007f66a9

 

[kenhamady]

Is this ANY LOJ in MAS90 or just a certain one? Even if it is just two tables?

It is always possible that MAS90 may not support LOJ in some/all situations. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[JonBartels]

Ken - Once again, thank you for your help.
I'm starting to suspect one of the tables, since LOJs work fine in other reports.
This particular table was not part of the plain vanilla software; it was set up by a consultant and has some custom "user defined fields".
I'm thinking the crash is caused by an ambiguous link, and that the custom table lacks an appropriate index field for a viable link.
The consultant will have to re-think the table. Jon

 

[bmitchel]

First, MAS90 only allows 1 left outer join. Crystal reports with MAS90 only allows equal, not equal, and left outer. Again, only one left outer can be used. Can you tell me which tables you were using with the left outer? I was a crystal developer with MAS90 and maybe able to help you.

 

[JonBartels]

Thank you for the info, and I appreciate your offer to help me further.
For now, this report has been put on hold, so I will not be spending any more programming time with it. Thanks again!