Merci Michael pour tous ces conseils, mais c’est la variable combinée qui ne marche pas !
SET VAR VNEWOBSTECH VARCHAR = (.VOBSTECH1+"þ"+.VDETREP) Elle ne produit aucun résultat, auriez-vous une idée ? Thanks Michael for all of this advice, but it's the combined variable that doesn't work! SET VAR VNEWOBSTECH VARCHAR = (.VOBSTECH1 + "þ" +. VDETREP) It produces no results, do you have an idea? Cordialement, JM De : rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] De la part de Michael Byerley Envoyé : jeudi 21 mai 2020 15:37 À : RBASE-L Objet : [RBASE-L] - Re: Varchar OK, Excepting that your statement would work, but not consistent with current structure: SET VAR VDETREP VARCHAR = DETREP IN LANCQUEST WHERE NUMQUEST = .VNUMQUEST Would be best restated as a SELECT clause like; Set var vDetRep VarChar = null Select DetRep into vDetRep ind Vin0 from LancQuest where NumQuest = .vNumQuest Using Select gives the opportunity throughout your system, of additional checks for null when required, by checking the INDICATOR variable value. 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f60916cb-fb6e-4683-90b5-e5b411fc4b25%40googlegroups.com<https://groups.google.com/d/msgid/rbase-l/f60916cb-fb6e-4683-90b5-e5b411fc4b25%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/427a87fc1bef47f1a78b8a4be2a8a033%40masse-charpente.fr.