Welcome Guest! Log in
×

Notice

The forum is in read only mode.
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…

Topic-icon Question SQL Operation

  • aminatou.sidikou@adias.fr
  • aminatou.sidikou@adias.fr's Avatar 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.
More
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
  • aminatou.sidikou@adias.fr's Avatar 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 :cheer: