MySql Database issues

[GeorgeS]

ok figured out the partial problem. I ran the query in my program and the reason I think it locked up is because it used up all memory and took forever to run.

I've got a compiler which creates the standalone .exe from a query, but it does not work as an .exe.

I solved this problem by running the query recursively, but it took me about an hour to run. It did find many 'null's however, which suprised me.

When I get this thing to work, i'll fwd you the solution.
George

[sesmar]

Yeah, I can run the query and it will take about an hour for it to run. I just wanted to know if anyone else was having this issue or if it was just me. I know this is possible to do and I know how to do it programatically I was just hoping that I would not have to do it that way because of the time it will take, it is kind of hard to make it a filter in your DB editor if it takes that long to run. I am just used to working with MS SQL Server and running a query like this never gives me a problem but that is a discussion for a different time and place. Anyways thanks for the feedback and confirmation of my problem.