CAPI Problem on Livelink 9.1.0.0.573 and SQL Server 2000 SP2
Hi,I am experiencing a strange problem with the following query on the CBNodeDeleteSubclass method of a customized LLNode:--->>> BEGIN: Query <<<--- dbResult = CAPI.Exec ( conn, \ "select dt.DataID as ID, ir.FT_ID as FT_ID, " + \ dbUser + ".AR_GetAttr_STR(dt.DataID, 'NCL Document', 'Status') as Status, " + \ dbUser + ".AR_GetAttr_STR(ir.FT_ID, 'NCL Document', 'Status') as NCLStatus, " + \ dbUser + ".AR_GetAttr_STR(dt.DataID, 'BIB Record', 'Role') as Role " + \ "from DTree dt left outer join AR_INISRecord ir " + \ "on dt.DataID = ir.ID " + \ "where dt.DataID = :A1", \ nodeVals[1].DataID )--->>> END: Query <<<---The query uses some customized SQL functions and tables to obtain an object's attributes and works well. The results are as I would expect them.The problem is that one particular result gets lost in the callback method where the query is executed. I have enabled full logging and <connect0.log> reports:--->>> BEGIN: SQL Log <<<---0000000873: ****** CAPIExec called ...0000000874: KSqlCursor::Open(2000,'select dt.DataID as ID, ir.FT_ID as FT_ID, llcurro.AR_GetAttr_STR(dt.DataID, 'NCL Document', 'Status') as Status, llcurro.AR_GetAttr_STR(ir.FT_ID, 'NCL Document', 'Status') as NCLStatus, llcurro.AR_GetAttr_STR(dt.DataID, 'BIB Record', 'Role') as Role from DTree dt left outer join AR_INISRecord ir on dt.DataID = ir.ID where dt.DataID = :A1') -->'SUCCESS'0000000875: KSqlCursor::Prepare() --> 'SUCCESS'0000000876: KSqlCursor::Bind(1,{20275}) --> 'SUCCESS'0000000877: KSqlCursor::Execute({'ID','FT_ID','Status','NCLStatus','Role'}) --> 'SUCCESS'0000000878: KSqlCursor::Fetch({20275,?,'INITIATED',?,?}) --> 'SUCCESS'0000000879: KSqlCursor::Close() --> 'SUCCESS'0000000880: KSql::Execute(...) --> 'SUCCESS',V{<'ID','FT_ID','Status','NCLStatus','Role'><20275,?,'INITIATED',?,?>},20 ticks--->>> END: SQL Log <<<---I am interested on the third value of the query: INITIATED. However, when I place an echo statement on the callback method: echo ( dbResult )to obtain the value as it is received in this method, I get:--->>> BEGIN: Echo Result <<<---V{<'ID','FT_ID','Status','NCLStatus','Role'><20275,?,?,?,?>}--->>> END: Echo Result <<<---The INITIATED value is gone. It's become undefined.Any ideas as to why this could happen or how I could fix it?Thanks, Curro
