You can't grammatically add to a varchar data, but you can select the the value from the primary table into a variable, then select the value to be added into another variable, combine the two variables, then update the primary table with the combined data.
So, if you had more than one instance of this to perform, you would have to do it using a CURSOR, as an UPDATE using a SELECT combining two sources will not work. On Wednesday, May 20, 2020 at 2:21:09 AM UTC-4, jmmasse wrote: > > > > Bonjour à tous, > > > > Utilisateur de Rbase depuis de très nombreuses années, je suis avec > beaucoup d’attention tout ce qui se dit sur le forum. > > John MINYO m’a inscrit récemment et je voudrais formuler une demande > concernant un champ « VARCHAR ». > > Dans une table j’ai un champ Historique de type « VARCHAR » qui concerne > des opérations de maintenance. > > Je voudrais enrichir cet historique en y rajoutant des données elles aussi > de type « VARCHAR » issues d’une autre table > > qui recense des opérations ponctuelles de façon à obtenir un historique > complet. > > Je me heurte à un message d’erreur qui m’indique que cela n’est pas > possible ! > > Auriez-vous une approche qui me permette d’obtenir ce résultat ? > > > > > > Good morning all, > > > > As a Rbase user for many years, I follow with great attention everything > that is said on the forum. > > John MINYO signed me up recently and I would like to make a request > regarding a « VARCHAR » field. > > In a table I have a History field of type "VARCHAR" which relates to > maintenance operations. > > I would like to enrich this history by adding data also of type "VARCHAR" > from another table > > which identifies specific operations in order to obtain a complete history. > > I run into an error message which tells me that this is not possible! > > Do you have an approach that allows me to achieve this result? > > > > Regards, > > > ------------------------------ > > *Jean-Marc Massé *(mobile : 06.08.82.80.86) > > Directeur > > Sté MCS > > 19, rue de la Mine > > 85510 ROCHETREJOUX (France) > ------------------------------ > > > > > > > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/5b6527b5-5cb0-46ef-bc4d-525e9f03fe1d%40googlegroups.com.
