John Baird
Coatesville, Pennsylvania, United States
>Hi,
>
>I just started using Stonefield Reports. I have changed my SYS(3055) setting to the max (2040?) and I'm still getting the 'Too many subqueries' error.
>
>I have something like the following:
>
>Court Cases (Case Number) related to:
> Defendants related to:
> People (Name)
> Arrest Warrants (Date Issued, Date Arrested)
>
>All primary keys are integer.
>
>When I do a report on names in People Date Issued and filter on EMPTY Date Arrested all works fine. WHen I add the Case Number it blows up w/the 'Too many subqueries' error. It doesn't seem THAT involved to me!
>
>Input is appreciated. J
Hi Jill:
I have had that error a few times and it is IMO usually related to faulty referential integrity. Make sure that all of your tables are linked by primary keys. You may want to post the Query that you are using also.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only