ADO query returns an integer from string field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The original data is a query, for which I am subsequently performing an SQL
query upon it. The field in the original query dataset is a String or
Character, yet when I perform an ADO SQL and print our using Debug.Print the
output is an integer. The query field is definitely a String, it prints out
as such in Print Preview. Where am I going wrong?
 
Please post the Code and if possible a copy & paste of the immediate
window. Also recheck the ADO statement. I would gather that its a
problem with the code. Characters don't just magically switch to numbers.
 
Thanks David. It appears the problem was due to the query storing the primary
key which was indexed to a data table. I was printing out the primary key in
the query but I was looking at joined reference in Dataview.
 
Back
Top