I am a very experienced database programmer in VB with Access and SQLServer.
I have built a database program in Delphi7. I have a data object which supplies the data to a form. On the form there are basically two grids with two different record sets.
I sort the data on the grids and add and remove data - nothing out of the ordinary.When I close the form I do quite a lot of processing in the query unload to update another table.
Now heres the thing - when I just open the form and close it there are no problems - the data is processed fine - so far so good - I can open and close the form 100 times.
It appears that after sorting the records on the form several of times (it can be ten times or 50 times) - when I close the form (and do the processing) I get a stack overflow error. There is no error in the Code - the data and Code in the query close event are unchanged.
I am absolutley not making recursive calls (looping etc) and it is impossible to pinpoint the problem - it appears random.
How can I find the problem/view/monitor the stack - what would be the effect of increasing the $MAXSTACKSIZE ?
Points for good answers onlty please - I have searched the Web High and Low - so