Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FoxPro / Setup / September 2004

Tip: Looking for answers? Try searching our database.

DO nesting ... level exceed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Edelbrok - 16 Sep 2004 02:02 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.