New topic: How to create a SQL statement to concatenate for RS Report
<http://forums.realsoftware.com/viewtopic.php?t=47292> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message tseyfarth Post subject: How to create a SQL statement to concatenate for RS ReportPosted: Thu Mar 14, 2013 10:19 pm Joined: Sat Dec 04, 2010 9:14 pm Posts: 850 Hello all, I want to take a FirstName Field and Concatenate that with a Last Name Field (with a space in between) then use that in a RS Report. My question is two fold: 1. What is the SQL command to do this? 2. What field do I tell the RS Report to use in the RS ReportField? Thank you! Tim Top timhare Post subject: Re: How to create a SQL statement to concatenate for RS RepoPosted: Thu Mar 14, 2013 10:32 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 12152 Location: Portland, OR USA What database? In sqlite, you could say select FirstName || ' ' || LastName As FullName Then tell Report to use FullName as the column name. Top tseyfarth Post subject: Re: How to create a SQL statement to concatenate for RS RepoPosted: Thu Mar 14, 2013 10:39 pm Joined: Sat Dec 04, 2010 9:14 pm Posts: 850 Hi Tim, Pervasive in this case. Tim Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
