Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to extract info from cursor?
Can anyone tell me how i might go about extracting the values from my queryresult which i store in a cursor?
Example:
i have a table with 3 data fields: a, b, c.
i execute an SQL query on above table and put the result into CURSOR called temp.
(Assume that queryresult is only a single row)
How would i retrieve individual values of a, b, and c from temp?
(Assume that queryresult is multiple rows)
How would i advance to the next row? And how can i backtrack a row?
Any help will be appreciated!
Many thanks :)
Mazlan Bin Mohammad
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement