• Replies 6 replies
  • Subscribers 336 subscribers
  • Views 100 views
  • Users 0 members are here
Related

Constituency end date and name

David Geoffrey Hall
$organization

Hi there,

I am using the Output Set Builder Cookbook for V11 (July 2012) and trying to get the Constituency end date and name output set working.

When I try and run the view SQL (LVXS_CONST_CUST_EXPIRED), I get an error that the view doesn't currently exist. I modified the code from ALTER VIEW to CREATE VIEW and ran it successfully. Now, when I try and use execute the output set I get the following error:

Invalid column name 'start_dt'
execute dbo.RP_RUN_QUERY;1 @query_no = 28, @list_no = 0

Any ideas why this isn't working?

Thanks,

David Geoffrey Hall

Parents
  • $organization

    Actually, now that I look at the Cookbook more closely, it looks like there is a typo at the end of the SQL to create the view. On page 13 it says:

    GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusers
    GO

    When it should actually say:

    GRANT REFERENCES, SELECT on [LVXS_CONST_CUST_EXPIRED] to impusers
    GO

    It's granting permissions to a different view - possible one you don't even have! Hopefully that can get changed in the documentation... :)

    Beth

Reply
  • $organization

    Actually, now that I look at the Cookbook more closely, it looks like there is a typo at the end of the SQL to create the view. On page 13 it says:

    GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusers
    GO

    When it should actually say:

    GRANT REFERENCES, SELECT on [LVXS_CONST_CUST_EXPIRED] to impusers
    GO

    It's granting permissions to a different view - possible one you don't even have! Hopefully that can get changed in the documentation... :)

    Beth

Children