#79 no carriage return displayed in procedure editing web widget

[Baptiste Mille-Mathias]

If you come to edit a procedure in the console in the web interface of Virtuoso , the widget is totally unusable as the carriage returns as not displayed.

for instance, a procedure I created in console like
CREATE procedure do_db_backup (IN backup_type VARCHAR)
{
declare backup_id VARCHAR;
declare block_size INT;
declare time_out INT;
declare backup_path VARCHAR;

backup_id := sprintf('%d_W%02d', year(now()), week(now()));
block_size := 5000;
time_out := 10;
backup_path := '/ke/data/virtuoso/backup/';
backup_type := initcap(lower(backup_type));

IF (backup_type = 'Full')
{
log_message('Full backup starting now');
log_message('Clear context');
backup_context_clear();
log_message('Checkpoint starting');
exec('checkpoint');
backup_online(sprintf('%s_%s_',backup_id, backup_type), block_size, time_out, vector(backup_path));
log_message(sprintf('Full backup done'));

RETURN;
}

IF (backup_type = 'Incr')
{
log_message('Incremental backup starting now');
log_message('Checkpoint starting');
exec('checkpoint');
backup_online(sprintf('%s_%s_',backup_id, backup_type), block_size, time_out, vector(backup_path));
log_message(sprintf('Incremental backup done'));

RETURN;
}

IF (backup_type <> 'Full' OR backup_type <> 'Incr')
{
log_message(sprintf('Wrong backup type, should be Incr or Full'));
RETURN -1;
}
}

in displayed this way in the edit web view

#line 18 "(console)"
create procedure do_db_backup (IN backup_type VARCHAR) { declare backup_id VARCHAR; declare block_size INT; declare time_out INT; declare backup_path VARCHAR; backup_id := sprintf('%d_W%02d', year(now()), week(now())); block_size := 5000; time_out := 10; backup_path := '/ke/data/virtuoso/backup/'; backup_type := initcap(lower(backup_type)); if (backup_type = 'Full') { log_message('Full backup starting now'); log_message('Clear context'); backup_context_clear(); log_message('Checkpoint starting'); exec('checkpoint'); backup_online(sprintf('%s_%s_',backup_id, backup_type), block_size, time_out, vector(backup_path)); log_message(sprintf('Full backup done')); return; } if (backup_type = 'Incr') { log_message('Incremental backup starting now'); log_message('Checkpoint starting'); exec('checkpoint'); backup_online(sprintf('%s_%s_',backup_id, backup_type), block_size, time_out, vector(backup_path)); log_message(sprintf('Incremental backup done')); return; } if (backup_type <> 'Full' OR backup_type <> 'Incr') { log_message(sprintf('Wrong backup type, should be Incr or Full')); return -1; } }

[Baptiste Mille-Mathias]

Instead of 'If you come to edit a procedure in the console' I meant 'If you come to edit a procedure created in the console'

[iODBC Maintainer]

Can you tell me which menu item in the conductor you are using to edit this procedure?

[Baptiste Mille-Mathias]

the work flow I use is the following:
- create the procedure given in console using isql.
- go to http://myserver:8890/conductor
- Click tab "Select", I arrive on "Schema Objects" page
- click on "DB" folder icon
- click on "Procedures" folder icon
- locate the procedure created previously in console, click on the "edit" link on the right hand corner.
- you can see the procedure in-properly displayed.