I have a stored procedure that simply opens a database and does a sql SELECT
of some records from it. It's all very simple and works most of the time.
But occasionally (I haven't figured out what makes this happen) I get the
message:
"Allowed DO nesting or expression evaluation level exceeded."
If I click the SUSPEND button the debug arrow points to my "OPEN DATABASE"
command, which by the way works all the rest of the time! It looks like
this:
"OPEN DATABASE ('c:\whp\cfm\cfms\production\dbas production')"
What is wrong? This is so frustrating. I run my stored procedure
successfully very often, but then for no apparent reason it starts giving
this nesting error and keeps persisting at it until who knows what makes it
go away. It is nothing to do with DO loops because I don't ever use any!
Thanks for help in advance,
Tom Edelbrok
Rick Bean - 16 Sep 2004 13:51 GMT
Tom,
What version and service pack level of VFP are you using? Do you get failures on selected machines or all of them? How is the SP called - i.e. does it get called from a loop, On Key Label, menu, etc.
Rick
> I have a stored procedure that simply opens a database and does a sql SELECT
> of some records from it. It's all very simple and works most of the time.
[quoted text clipped - 17 lines]
>
> Tom Edelbrok