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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f60916cb-fb6e-4683-90b5-e5b411fc4b25%40googlegroups.com.