try this and it will work
update Table
set NextDate =
(select Table1.Date
FROM Table1
where Table1.CompID = Table.CompID + 1)
where Table.CompID < (biggest value for Comp id )
first i want to know
is
1. the variables you use what is its values
you must use the block items on the screen which have data
2. check if auditing_inserts is a database block
Dear friend
when u call a report by RUN_PRODUCT use 'SYNCHRONOUS' option not 'ASYNCHRONOUS' try it and it will be fine
RUN_PRODUCT(REPORTS,'ReportName',SYNCHRONOUS,RUNTIME,FILESYSTEM,
'paramformlist');
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.