Hi,
I would like to know if there is a way to log automatically database record creation (the way as we already have for some -clientlog -logentrytypes startup parameters).
I know it is possible with Temp-table (Progress KB - Is there a LOG-ENTRY-TYPE to log TEMP-TABLE statistics?) but for physical database record I don't know.
For example, I would have something like this :
In my clientlog I would like to have something like this :
4GL 4GLTRACE Run MyProcedure [Main Block - c:\temp\p60345_Untitled1.cmp @ 4]
4GL TABLE Created TABLE MyDataBase.MyTable (ID:57 Indexes:1) MyProcedure c:\temp\p60345_Untitled1.cmp @ 7
4GL 4GLTRACE Return from MyProcedure [c:\temp\p60345_Untitled1.cmp]
(The 2nd Line, in red, is fake of course - I took an example on the same feature for temp-table, but it represents what I would like to have)
My initial issue is that somewhere in my code (I don't know where) I have a record creation which causes problem and I would like to identify at least the internal procedure which create this record (with line number if possible).
My code is quite heavy and contain many sub-procedure with dynamic stuff so it is not really easy. Currently my code is only client-server direct connection (no use of appserver, everything is called from Windows client side)
For info, I use Progress OpenEdge V11.5.1 on Windows XP SP2 OS.
Have you any advice ?
Thanks in advance.
Regards,
I would like to know if there is a way to log automatically database record creation (the way as we already have for some -clientlog -logentrytypes startup parameters).
I know it is possible with Temp-table (Progress KB - Is there a LOG-ENTRY-TYPE to log TEMP-TABLE statistics?) but for physical database record I don't know.
For example, I would have something like this :
RUN MyProcedure.
PROCEDURE MyProcedure :
PROCEDURE MyProcedure :
CREATE MyDataBase.MyTable. /*create a physical database record*/
END PROCEDURE.In my clientlog I would like to have something like this :
4GL 4GLTRACE Run MyProcedure [Main Block - c:\temp\p60345_Untitled1.cmp @ 4]
4GL TABLE Created TABLE MyDataBase.MyTable (ID:57 Indexes:1) MyProcedure c:\temp\p60345_Untitled1.cmp @ 7
4GL 4GLTRACE Return from MyProcedure [c:\temp\p60345_Untitled1.cmp]
(The 2nd Line, in red, is fake of course - I took an example on the same feature for temp-table, but it represents what I would like to have)
My initial issue is that somewhere in my code (I don't know where) I have a record creation which causes problem and I would like to identify at least the internal procedure which create this record (with line number if possible).
My code is quite heavy and contain many sub-procedure with dynamic stuff so it is not really easy. Currently my code is only client-server direct connection (no use of appserver, everything is called from Windows client side)
For info, I use Progress OpenEdge V11.5.1 on Windows XP SP2 OS.
Have you any advice ?
Thanks in advance.
Regards,