Razzak, I did change the one variable vShort as you suggested but it did not change the outcome. All the var I am combining are either NOTE or TEXT fields.
I traced again and find the var vshipnotes goes null when I run an EEP from a field that goes to a detail table and gets the model information. This is the code: SELECT (LISTOF(DISTINCT Model#)) INTO + vModelList INDIC IvModelList FROM tOrderShip + WHERE Control# = .vControl RECALC VAR .vShipShort RETURN (vShipshort is the var that combines all the other var into one). Then I get some address info with this EEP. SELECT Distname,DistAdd1,DistCity,DistState,DistZip INTO + vDistName INDIC ivDistName, + vDistAddress INDIC ivDistAddress, + vDistCity INDIC ivDistCity, + vDistState INDIC ivDistState, + vDistZip INDIC ivDistZip + FROM DistInfo WHERE DistID# = .vDistID IF .vDistID = 'CRST' THEN SET VAR vKPRName = 'Kay Park-Rec Corp' ENDIF IF .vDistID = 'KAYPRK' THEN SET VAR vKPRName = 'Kay Park-Rec Corp' ENDIF RETURN The "junk" information enters here from the vDistname or vDistaddress variables. They have nothing to do with the vShipnotes var. or the combined var. When I get to my last variable that combines everything and saves the row, the combined var shows all the proper info EXCEPT it has the strange info instead of the vshipnotes var info. The minute I save the row on that last var, the proper info repopulates the vshipnotes variable but of course the combined var already has the junk info. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, November 25, 2009 11:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gremlin in Form At 11:53 AM 11/25/2009, Jim Belisle wrote: >I created a form in which I am concatenating multiple text and note >fields into one field. >I had it working then sometime over the weekend one var started >giving me odd information. >I will try to be brief but thorough. In the expression builder I >create the following >variables. > >vshort = (SHORTAGES MUST BE NOTED ON BILL OF LADING AND REPORTED TO >DRIVER IMMEDIATELY) >vshipnotes = (shipnotes) Add quotes when defining a variable with TEXT data. -- Example: vShort = ('SHORTAGES MUST BE NOTED ON BILL OF LADING AND REPORTED TO DRIVER IMMEDIATELY') What are the data types of all variables involved with concatenated variable? That should give you some blue's clues! Very Best R:egards, Razzak.
