>Hi,
>
>I am trying to figure out why a log file sometimes does not have a certain value.
>
>Here is an example:
>In some programs (.prg), to check if the connection to SQL Server is valid, the code calls the application object property conn_handle. As this:
>
>oApp.conn_handle_source = 5
>=oApp.conn_handle
>
>
>In the application class, when the call to oApp.conn_handle is made (via =oApp.conn_handle), the following method is fired: PROCEDURE conn_handle_access
>This method (conn_handle_access) checks the connection. And if it is good, the following entry is logged:
>
>local cCalledFrom
>cCalledFrom = ""
>IF this.conn_handle_source > 0
> cCalledFrom = " Called From " + ALLTRIM(STR(this.conn_handle_source))
>ENDIF
>
>LOCAL ARRAY aStackArray[1,1]
>ASTACKINFO(aStackArray)
>cCalledFrom = CHR(13) + CHR(10) + SPACE(22) + cCalledFrom + " Program: " + aStackArray[alen(aStackArray,1)-1,2] + " Module: " + aStackArray[alen(aStackArray,1)-1,3]
>
>STRTOFILE( TTOC(DATETIME()) + " oApp.conn_handle_access(). " + cCalledFrom + CHR(13) + CHR(10), cLogFilePath + cLogFileName, 1 )
>
>
>
>The problem is that sometime the .log file does not have the "Called From #" but only "Program:.... "
>As if the value in property this.conn_handle_source is 0 (zero). But I check the code and a value (a number) is always assigned.
>Why would the it not be in the log file?
>Anybody see something wrong with the code above?
>
>TIA
I found something that maybe causing the problem I described above. But I need to clarify something:
I have this function:
FUNCTION GetSqlConnectHandle
RETURN oApp.conn_handle
Does the code above, RETURN oApp.Conn_handle fires the method oApp.conn_handle_access?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham