I cannot see all that you have done, but the following works for me. *( Begin TEST CODE)
SET VAR vIdx INTEGER SET VAR vc1 VARCHAR SET VAR vc2 VARCHAR SET VAR vc3 VARCHAR SET VAR votherdata VARCHAR -- I always use a variable to hold CARRIABE RETURN + NEW LINE instead of Literal character when combining text. SET VAR vCrLf TEXT = ((CHAR(031)) + (CHAR(010))) DROP CUR c1 DECLARE c1 CURSOR FOR SELECT idx, colvc1 colvc2 FROM testvarchar + WHERE idx = 2 OPEN c1 FETCH c1 INTO vIdx IND vIn0, vc1 IND vIn0, vc2 IND vIn0 SELECT cmddata INTO votherdata IND vIn0 FROM testcontvc WHERE cmdname = 'Startup' WHILE SQLCODE = 0 THEN SET VAR vc3 = (.vc1 + .vcrlf + .vc2 + .vcrlf + .votherdata ) UPDATE testvarchar SET colvc1 = .vc3 WHERE CURRENT OF c1 --UPDATE testvarchar SET colvc1 = NULL WHERE CURRENT OF c1 FETCH c1 INTO vIdx IND vIn0, vc1 IND vIn0, vc2 IND vIn0 ENDWHILE DROP CUR c1 RETURN *(End Test Code) *( Explanation ) *( Table TestContVC contains VarChar Column containing value: Startup startup SELECT Table TestVarChar has 4 columns: IDX Integer, ColVC1 VarChar, ColVC2 VarChar, ColVC3 VarChar Cursor row IDX = 2 ColVC1 = Jean-Marc Massé ColVC2 = 85510 ROCHETREJOUX ColVC3 = null *It is IMPORTANT to declare ALL variables used BEFORE use in code. DO NOT rely on RBASE to do type conversion for you for greatest reliability. ) On Friday, May 22, 2020 at 4:46:30 AM UTC-4, jmmasse wrote: > > 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 :* rba...@googlegroups.com <javascript:> [mailto: > rba...@googlegroups.com <javascript:>] *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 rba...@googlegroups.com <javascript:>. > 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/b8c2a235-e741-4fda-949f-3c8976b38eba%40googlegroups.com.
