Pro*C Cursor-Update problem 
Author Message
 Pro*C Cursor-Update problem

I've the folowing problem in Pro*C:
I'have a cursor, reading from the database.
Every fetched record has to be updated. So I do an
update in the loop, but this corrupts the cursor.
How can I solve this.

Luc



Sun, 27 Aug 2000 03:00:00 GMT  
 Pro*C Cursor-Update problem



Quote:
>I've the folowing problem in Pro*C:
>I'have a cursor, reading from the database.
>Every fetched record has to be updated. So I do an
>update in the loop, but this corrupts the cursor.
>How can I solve this.

Shrug. The standard C language doesn't support cursors or database
updates, so you will have to go to a more appropriate forum.

There is probalby some trick for doing what you want, because it's not an
uncommon requirement to want to iterate over some database records and change
some of them.



Sun, 27 Aug 2000 03:00:00 GMT  
 Pro*C Cursor-Update problem

Though this sounds very much like a C question, I think you will get better


--
Hypertext C-FAQ: http://www.eskimo.com/~scs/C-faq/top.html
C-FAQ ftp: ftp://rtfm.mit.edu, C-FAQ Book: ISBN 0-201-84519-9
Try "C Programming: A Modern Approach" ISBN 0-393-96945-2
Want Software?  Algorithms?  Pubs? http://www.infoseek.com

Quote:

>I've the folowing problem in Pro*C:
>I'have a cursor, reading from the database.
>Every fetched record has to be updated. So I do an
>update in the loop, but this corrupts the cursor.
>How can I solve this.



Sun, 27 Aug 2000 03:00:00 GMT  
 Pro*C Cursor-Update problem

Quote:

> I've the folowing problem in Pro*C:
> I'have a cursor, reading from the database.
> Every fetched record has to be updated. So I do an
> update in the loop, but this corrupts the cursor.

        Pro*C is a specialised language used exclusively in connection with
the Oracle line of database products.  You would probably get a better response

from your loop relevant to the cursor when you post your problem there.

                                                                -- Stone



Sun, 27 Aug 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. PRO*C,Cursor Limits,Reducing the cursor requirement:HELP

2. VC++ 6.0 Pro installation problem in Win2000 Pro

3. VC++ 6.0 Pro installation problems under Win2000 Pro

4. Newbie: separate big .cs file into small .cs files

5. Problem #30 on http://cs.nmu.edu/programming/c/problems.htm

6. How do I turn off all form and mouse cursor updates

7. Numeric fields cause intermittent CRecordset update failures with ODBC cursor library

8. Float numbers update in Client Side cursors.

9. Cursor does not update until mouse moved

10. cursor not updated

11. Mouse Cursor forced updates

12. VC++ Pro 2003 Trial not Pro

 

 
Powered by phpBB® Forum Software