Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Question SQL Operation

Start
Prev
1
Next
End

aminatou.sidikou@adias.fr
Topic Author

06 Jun 2016 10:52 - 06 Jun 2016 10:55 #1 by aminatou.sidikou@adias.fr

SQL Operation was created by aminatou.sidikou@adias.fr

Bonjour

j'ai un sdlOperation qui fait :

insert into table1 (...............) select (${val1}$, champ1, champ2) from table2;

${val1}$ n'est pas un champs de la table2

Stambia lit le contenu de la variable mais considère la valeur comme un champ, et retour une erreur

Avez vous la moindre idée sur comment le résoudre?
Merci infiniment

Last edit: 06 Jun 2016 10:55 by aminatou.sidikou@adias.fr.

Thomas BLETON
Offline

06 Jun 2016 16:11 #2 by Thomas BLETON

Replied by Thomas BLETON on topic SQL Operation

Bonjour

Avez-vous essayé d'ajouter des quotes autour de la valeur ? Comme ceci :
insert into table1 (...............) select ('${val1}$', champ1, champ2) from table2;

aminatou.sidikou@adias.fr
Topic Author

06 Jun 2016 18:57 #3 by aminatou.sidikou@adias.fr

Replied by aminatou.sidikou@adias.fr on topic SQL Operation

Merciiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

Ça marche

Start
Prev
1
Next
End