Edit C:\Users\Administrator\Desktop\CGI\LIVRAISONS\V1.6.3\Livraison_20230627\01-BDD\update label confirmation + ordre reponse.sql

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');

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de