Are you trying to get it back as 1 field?
I'm not sure about SQLite - but I know with MySQL you can use CONCAT:
SELECT CONCAT(name, '\r\n', address, '\r\n', zipcode) AS person_info
FROM people
That returns 1 field called person_info
OR
You can grab the separate fields and stitch them together in RB:
Dim s As String
s = rs.Field("name").StringValue + "\r\n" + rs.Field("address") + "\r
\n" + rs.Field("zipcode")
or something simple like that
Regards,
Stephen
On 17-Jul-06, at 8:22 AM, D Jungk wrote:
Hi,
I'm getting started with the database features of RB for the first
time and
have a question about the SQL queries. With a ListBox bound to a
DatabaseQuery I can use something like:
SELECT age + shoesize FROM People
and I get back a column with the total of two numbers.
Is there a way to do the same with strings? something like:
SELECT name + EndOfLine + address + EndOfLine + zipcode
In FileMaker Pro we have a "&" operator that does this.
Thanks,
Don Jungk
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
