[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference marin::forte-ft

Title:Forte' Field Test Conference
Notice:Forte R3 is due in summer...with lots of NEW features
Moderator:MARIN::ARVIND
Created:Wed Aug 04 1993
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:919
Total number of notes:3356

900.0. "CloseCursor: unexpected XactState" by ALCALA::VIEJO () Mon Jan 27 1997 03:13

T.RTitleUserPersonal
Name
DateLines
900.1TOOL does use cursors.KETJE::GHYOOTReal systems are complex!Sun Feb 02 1997 23:5716
    Ola Luis,
    
    Although _you_ don't use cursors explicitly, TOOL uses them a lot
    behind the scenes to implement a number of operations.
    
    For example, the integrated for loop
    	for obj in sql select ....
    is implemented by means of a cursor.
    
    As to the conditions in which the message is being raised... You should
    try to do some lower level SQL tracing to find out more about them.
    Sorry I can't help more for now.
    
    Kind regards,
    
    Jean-Michel
900.2cursorsMARIN::CONNORMon Feb 10 1997 14:436
    Try using the trace flag 
    
    	trc:db:1  for Cursor operations
    
    		-steve C.
    
900.3SQL Prepare tracingMARIN::CONNORMon Feb 10 1997 14:444
    also, trc:db:3  Trace SQL Prepare statements
    
    	-steve C.