Line not saving when creating a chart.

(2 posts) (2 voices)
  • Started 2 months ago by msaiko239
  • Latest reply from myDBR Team

Tags:

No tags yet.

  1. msaiko239, Member

    Hello,
    I am trying to create a chart and running into a problem. when I edit my SQL code to show
    create procedure sp_DBR_FilmByCategoryChart() begin

    select 'dbr.chart', 'Pie', 'Sample Pie chart';

    select category, total_sales from mydb.sales_by_film_category;

    end
    I can hit execute and the lines
    select category, total_sales from mydb.sales_by_film_category;
    Do not save.
    If I exit and go back to edit the report they are gone. Everything before the first ';' stays.

    Posted 2 months ago #
  2. myDBR Team, Key Master

    if you have text selected and click "Execute", only the selected text will be executed. If you have no text selected, all queries in the editor will be executed.

    --
    myDBR Team

    Posted 2 months ago #

Reply

You must log in to post.