>>>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
>
>Hi,
>
>Yes.
>
>MartinaJ
Thank you, Martina! This could be a cause of many problems. Now I just need to find a rope lol
"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