>>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 && or a different number depending on where the check is made)
>>=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