I have a select statement that is sort of like this
select drive, path, filename, “.txt” from Table where name=“foo”;
This generates a nice record set with 4 columns / row.
I need two columns per row.
I need to do that by combining drive, path and filename using string methods
drive looks like C, path looks like root, filename looks like foo
what I need those three combined together to look like is
C:\root\foo.txt
This isn’t to be done within Xojo code but within the sql statement … somehow…