Re: mysql with subs

2003-02-14 Thread erwan ancel
Hi, I have had this type of problems. Under Oracle, the CONNECT BY statement was done for such queries if I can remember. But I don't know if mysql can handle this statement, or has an equivalent. Erwan - Original Message - From: Peter Grigor [EMAIL PROTECTED] To: Lars Rasmussen

Re: Applications for creating reports for MySQL

2003-02-07 Thread erwan ancel
I have tried report manager http://reportman.sourceforge.net/ that works fine ans is in opensource. The big trouble of it for me is that is is written in delphi with borland tools. I made a dll with C++ builder to be able to use it in C/C++ with the gnu compilers. It works, but gdb crashes when it

partial commit

2003-02-03 Thread erwan ancel
Hi everyone. Does anybody know if it is possible to commit only partially ? example: query: select ... from A ... for update; // update fields locked in A query: select ... from B ... for update; then I would like to commit all changes I did in the locked records from table A,