• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

Stack overflow in VB, how to prevent/control

I created a VB program which is in the process of development. The stage
I am in now, I simply acess a data base of 8000 stocks and transfer all
available price data which is available for whatever is in the data base
into indexed locations for (open, high, low, close, volume & date). I
transfer this for each stock and when I am still in the A stocks I get a
stack overflow.  I know what a stack is, but have no idea how to control
same (clear it out or change it's size with respect to VB use of same.
What should I do to control the size, prevent overflow.

Each time I go to access the new stock I cycle through various SUBs
which perform task like 'increment the index' and pass control back in a
loop which possibly produces a continuous series of the same stack
entries.  If I work to prevent these loops, will that solve my problem.
Doing so just makes me repeat the same code in many places and violates
my sense of good practice.   Thanks
0
WinniePough
Asked:
WinniePough
1 Solution
 
amebaCommented:
Some stack error causes:
1. Reentering some procedure,
2. Usage of DoEvents,
3. Too big local variables (big string or array declared at procedure level)

For 1 and 2 check program logic; add flags to control 'states'.
For 3 - move your big array or string declaration to MODULE level.

If this doesn't help, post some code... e.g. procedure which gives stack error.
0
 
DanRollinsCommented:
Hi WinniePough@devx,
You've requested to delete this question, but its status remains as 'Pending Delete' because one or more comments have been added.  Normally, the only way to fully delete such a Question is to post a message to Community Support and ask for assistance.

EE is making a one-time database sweep to purge the Pending Delete Questions automatically.  During this sweep:

    WinniePough@devx -- To allow the deletion to proceed:  Do nothing.
    EXPERTS -- Please DON'T POST a comment except to contest this deletion.

In the future, please refer to http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.

DanRollins -- EE database cleanup volunteer
0
 
MoondancerCommented:
Finalized by Moondancer - EE Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now