Not all rows editable in linked reports

(2 posts) (2 voices)


No tags yet.

  1. An interesting problem. I have 2 linked reports, the first one calling the second thus:

    select '', 'sp_DBR_Product_Entry_Edit', '[product]', 'popup', 'zID=[pid]', 'zDescr<=Descr', 'zFulldescr<=Fulldescr', 'zKeywords<=Keywords';

    I am using the [column reference] this way, for shorthand:

    select x.productid as 'Productid[pid]', . . .

    Using the column name itself, Productid, doesn't seem to make any difference in the problem I am having.

    It returns the appropriate records, and the [product] column text is underlined, as one might expect for a link. The problem is, some of the links open up a popup for editing and everything works. Some do not. The rows that do not work have single quote characters in the text for the product column.

    Now, I bet I can just add a column to use for the popup, but would love to know if there is a programmatic way to escape these single quotes so that the javascript does not get confused.

  2. myDBR Team, Key Master

    This bug has been fixed in the latest build. Run the updater to get one. No changes needed for your code.

    myDBR Team


You must log in to post.