Icetips Utilities Documentation 5/7/2015     String Class:  StringFromLines

Previous  Top  Next

This method constructs a string from the Lines queue and returns it.  

Example:

ITS  ITStringClass

SQL  CString(1025)

CODE

ITS.AddLine('SELECT TOP(1) CAST(MonthStartDateTime AS DATE) AS MonthStartDate',TRUE)

ITS.AddLine('  FROM dbo.PropertyToDo')

ITS.AddLine(' ORDER BY MonthStartDateTime DESC')

SQL = ITS.StringFromLines()

The resulting string will look like this:

SELECT TOP(1) CAST(MonthStartDateTime AS DATE) AS MonthStartDate

FROM dbo.PropertyToDo

ORDER BY MonthStartDateTime DESC

This makes it easy to construct SQL statements for example

See also:

LinesToString
LineString