I am trying to make a unique (but repeatable) reference by concatenating a string with a timestamp as part of an Access 97 query via the Sun ODBC-JDBC connector wit iReport:
tbl_PET_Pet.Pet_Time_Updated + tbl_PET_Pet.PET_Pet_Reference as uniqueid
The report complains that the textfield cannot be cast from a timestamp to a string so I have tried various permutations in the query, such as:
cast (tbl_PET_Pet.Pet_Time_Updated as varchar(20)) + tbl_PET_Pet.PET_Pet_Reference as uniqueid,
But the query won't build - Missing Operator.
Am I getting the syntax wrong for an ODBC query?