>>>******************************************************************** >>>* Description.......: FieldsToString - creates a string with fields in a table >>>* Calling Samples...: >>>* Parameter List....: tlAddTypes, tlAddAlias >>>* Created by........: Nadya Nosonovsky 04/21/2005 >>>* Modified by.......: *-- CHANGE - NN - August 10, 2005 - 15:10:45 >>>******************************************************************** >>>FUNCTION FieldsToString >>>LPARAMETERS tlAddTypes, tlAddAlias >>> >>>LOCAL lcStr, lnI, lnFields, laFields[1], lcType >>>lnFields = AFIELDS(laFields) >>>lcStr = "" >>> >>>FOR lnI = 1 TO m.lnFields >>> lcType = laFields[m.lnI,2] >>> lcStr = m.lcStr + ", " + IIF(m.tlAddAlias,ALIAS() + ".", "") + laFields[m.lnI, 1] + ; >>> IIF(m.tlAddTypes, " " + m.lcType + ; >>> IIF(NOT INLIST(m.lcType, "D","T","I","G","M","Y"), "(" + TRANSFORM(laFields[m.lnI,3]) + ; >>> IIF(laFields[m.lnI,4] > 0, ", " + TRANSFORM(laFields[m.lnI,4]),"") + ")",""),"") >>>NEXT >>>_cliptext = SUBSTR(m.lcStr, 3) >>>************************************************************************