BubikolRamios
08-13-2009, 08:49 AM
Forget this, bug somewhere else.
DECLARE cur CURSOR FOR
SELECT tmp
FROM tmpTable;
.. 1. drop tmp table if exists, create tmp table, fill it with data
OPEN cur;
... do domething with data, data is here and all OK
CLOSE cur;
.. 2. drop tmp table if exists, create tmp table, fill it with data the same as in 1 for test
OPEN cur;
..--> hmm --> no data in cursor ?
DECLARE cur CURSOR FOR
SELECT tmp
FROM tmpTable;
.. 1. drop tmp table if exists, create tmp table, fill it with data
OPEN cur;
... do domething with data, data is here and all OK
CLOSE cur;
.. 2. drop tmp table if exists, create tmp table, fill it with data the same as in 1 for test
OPEN cur;
..--> hmm --> no data in cursor ?