WinniePough
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Finalized by Moondancer - EE Moderator
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 https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp#8 for instruction on deleting questions.
DanRollins -- EE database cleanup volunteer