ADO query returns an integer from string field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EricC4S - 23 Sep 2005 08:20 GMT

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?

Reply to this Message

David C. Holley - 23 Sep 2005 10:19 GMT

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.

> 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?

Reply to this Message

EricC4S - 28 Sep 2005 08:01 GMT

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.

> 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
[quoted text clipped - 5 lines]
> > output is an integer. The query field is definitely a String, it prints out
> > as such in Print Preview. Where am I going wrong?

Reply to this Message