Hi Stephen,
> Are you trying to get it back as 1 field?
yes
> I'm not sure about SQLite - but I know with MySQL you can use CONCAT:
>
CONCAT apparently isn't part of SQLite, but thank you for your answer. The bit
you added below will help me too, as I am just starting out with SQL and
using the REAL database stuff.
>
> Dim s As String
>
> s = rs.Field("name").StringValue + "\r\n" + rs.Field("address") + "\r
> \n" + rs.Field("zipcode")
>
Thanks,
Don
_______________________________________________
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>
