Pick up January and February based on System Year.: Edit Code

[Former Member]

Hello Friends

Message was edited by:

soniya kapoor

[former_member195698]

Where exactly its failing ? Have you checked that through debugging. Is the data present in the database table which the query is checking.

Just check the place at which the select query is failing. Also check whether Modify statement is failing.

Once you have found the Place at which the failure is occuring then we can check on the query which is causing the failure.

If all the Queries are passing successfully, then try using COMMIT WORK and WAIT statement after the endloop.

The data might not have been committed.

Regards,

Abhishek

[Former Member]

What format is "FISCPER" stored in? Your comment at the start says "001.2007" but in your code you are concatenating Year & '001' which will result in "2007001"...? So perhaps the code should read

concatenate '001.' curr_year INTO Jan_Currentyear.

Jonathan