I have the following code.
dim rs as recordset = karter.SQLSelect("select * from mytracks where PK = "+ str(mytrackspk))
txtspacers1.text = DefineEncoding(rs.Field("spacers").stringvalue, encodings.UTF8
This code works fine when pulled from the database, spacers is a size ie 12, how do I append another value to the spacers value, pulled from another record set as follows.
dim rs2 as recordset = karter.SQLSelect ("select currency, measurement, temperature from preferences")
I wish to append the measurement value from the database, which in this case in “mm”