Slow ODBC Queries with Crystal

kevinnNew Member

I have been corralled into writing some Crystal Reports for Maximizer and I am running into a issue with incredibly slow Queries with UDFs. I have traced some of the issue to Crystal Generating bad SQL, but I am not able to perform a proper join using PCC (Pervasive Control Center) that returns the 7,000 or so records I am expecting. Has anyone come across this issue? I am fairly new to pervasive, but I don't see any Primary/Foreign Key relationships like I would expect to see in SQL Server or Access (BTW, I run into the same issue when I perform a inner/outer join on a linked Access table).

11/16/069:25 PM

❤️ 0

Original Post

kevinnNew Member

I believe I have found where the issue is, I am now trying to solve that issue. I cannot seem to generate a simple Inner Join Sytnax within Pervasive. I am expecting to get approx. 7000 records, but when I use a inner join (which I believe is supported) it returns 0 rows. Even when I use a outer join (Left or Right) I only get 42 records. Is there a setup flag in Pervasive that forces the use of SQL 92 syntax?

This is the Query I wish to run.

Select u.myUDF, c.Name, c.first_name From
myUDFView u Inner Join MyClientTable c ON
u.client_id = c.client_id AND u.contact_number = c.contact_number.

11/17/062:51 PM

❤️ 0

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...