update "label"
set lbllabel = 'Si vous avez terminé votre saisie, n’oubliez pas de cliquer sur - J''ai terminé ma saisie et je valide mon inscription au guide - (en bas de l’écran).
Vous avez toujours la possibilité de compléter ou modifier votre questionnaire en cliquant sur le lien ci-dessous'
where lblid = (select lblid from "label" inner join refvalues on lblcodelng = refid where lblcodemsg = 'MF10B' and refval = 'fr_FR');
update "label"
set lbllabel = 'Se ha terminato l''inserimento, non dimentichi di firmare (cliccando su ''FIRMARE'' nella parte inferiore dello schermo).'
where lblid = (select lblid from "label" inner join refvalues on lblcodelng = refid where lblcodemsg = 'MF10B' and refval = 'it_IT');
update "label"
set lbllabel = 'Se ha terminado la introducción de datos, no olvide firmar (haciendo clic en “FIRMAR” en la parte inferior de la pantalla).'
where lblid = (select lblid from "label" inner join refvalues on lblcodelng = refid where lblcodemsg = 'MF10B' and refval = 'es_ES');
update mvafqtrefsdisp_
set mvaposition = 0
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'CB');
update mvafqtrefsdisp_
set mvaposition = 1
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'JCB');
update mvafqtrefsdisp_
set mvaposition = 2
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'MASTER');
update mvafqtrefsdisp_
set mvaposition = 3
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'AMEX');
update mvafqtrefsdisp_
set mvaposition = 4
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'DINERS');
update mvafqtrefsdisp_
set mvaposition = 5
where mvaid = (
select mvaid from mvafqtrefsdisp_ m
inner join refvalues r on m.mvatext = r.refid
where m.mvacolid = (select f.fqtid from formquestion f where f.fqtseqnum = 190)
and r.refval = 'ANCV');