×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Foreach - where current of problem...

Foreach - where current of problem...

Foreach - where current of problem...

(OP)
I get an error (255 - not in transaction) on this procedure. Yet I can't seem to cure it with begin work/commit work. Perhaps I'm just inept.

It only fails when the "where current of" is there in the update. If I don't use "current of" it works, but then I need to use a more timeconsuming where clause.

How do I fix it up to work?


CREATE PROCEDURE spl_fix_akt_datum()
  DEFINE dok_datum,start_datum,stop_datum,x DATETIME YEAR TO SECOND;
  DEFINE dok_datum_int,start_datum_int,stop_datum_int INT;
  DEFINE z INTERVAL SECOND(9) TO SECOND;
  DEFINE q CHAR(20);

  FOREACH cursor1 FOR
    SELECT dok_dt_int, start_dt_int, stop_dt_int
    INTO dok_datum_int, start_datum_int, stop_datum_int
    FROM j_akt_transfer
    [...]
    UPDATE j_akt_transfer SET dok_dt="2000-01-01 00:00:00"
    WHERE CURRENT OF cursor1;

  END FOREACH;

END PROCEDURE -- spl_fix_akt_datum


Thanks in advance,

Anders

RE: Foreach - where current of problem...

SELECT ... FOR UPDATE !!!!!!!!!!!!!

or why not

UPDATE yourtable SET yourcolumn='newvalue' WHERE anything AND everything

sometimes dateformat works only in local dbaccess

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close