1. 

   elb98rm, Member

   I have a problem transferring a few vars between the 2 reports.

   The first report is the normal display, the second report is to process a DB write.

   However: As I've been debugging things it seems that I have noticed.
   Is there a limit on the number of variables that you can pass?

   I'm trying to pass 5, and they seem to not work after 3.

   Here's the relevant parts of the code:

   Code inside part 1:

   select 'dbr.editable', 'status', 'sp_DBR_ons_venue_pack_summary_01', 'inEmployeeId=eid', 'inSeason=season', 'inVenueId=vid', 'inUdId=udid';

   Code inside part 2
   CREATE PROCEDURE sp_DBR_ons_venue_pack_summary_01(
   inEmployeeId int,
   inSeason char(45),
   inVenueId int,
   inStatus int
   inUdId int
   )

   If I simply return a var (eg: select inEmployeeId), then this works UP TO inVenueId. For inStatusId and inUdId this stops working.

   At this debugging stage I can clearly see that inStatusId and inUdId are correctly populated in part 1.

   Can you shed any light?

   Cheers
   Rick
2. 

   myDBR Team, Key Master

   There is no limit on the number of parameters. In editable reports the editable value to be passed in the editing report is always the last one and it is automatically added.

   In your repot you have the last one (inUdId) defined, but the one in the middle (inStatus) is not. Try to change order of these two.

   --
   myDBR Team
3. 

   elb98rm, Member

   Hi, sorry - I got asked to do some other work.
   I've returned to look at this and yes! Changing the order (amongst some other debugging) solved the problem.

   Top tip!

Reply

You must log in to post.