My -layout is not as expected: Why does .getstring create a single cell at the end of the table? Is this a bug? Can you fix this via getrow and join?
Thanks for your tips
It's a known... well, annoyance. (Otherwise known as a bug that will never get fixed.) You either have to trim off the extra delimiters using Left()
, or you have to use something other than .GetString
. .GetRows
is probably the most useful, but note that you can't use Join
with it: the latter requires a one-dimensional array, while GetRows
always returns a two-dimensional array, even if the recordset only returned one column and/or row.