Information générale
Catégorie:
Codage, syntaxe et commandes
You can use the result of the SELECT-SQL as you use any other table. Only that the result set is read-only.
Vlad
>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
Précédent
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