Question on Paradox 8 .vs. Access Queries

[jrlane]

I am converting a Paradox 8 based application to Access 2007. It appears that often Paradox queries drop out records and Access includes them. To the best of my ability the test data is the same and the queries are the same. I am looking at Paradox quereis written in the PAL script .vs. Access graphical queries. I've tried Access/SQL Select Dinstinct and no help. Anyone got any ideas? Thanks.

 

[TonyMcGuire]

You are comparing DOS-based Paradox PAL scripts to windows-based Access graphical scripts?

Sorry, I don't have Paradox for DOS any longer to help with that one.

One thing that will help people trying to help you would be examples of each (better the actual ones that are succeeding and the one that is failing).

Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[jrlane]

Yes, it's a turn of century application and I think it originally ran on DOS. Now it runs on Windows XP. I wonder if a Paradox engine property is affecting it?