Post reply

Quick One: Works in Query Analyzer - NOT in Code

  • February 26, 2004 at 11:22 am

    #86088

    Hopefully, this will be a very quick one.

    We have a query built in VB.  It reads something like this (not the actual code :

    "Select aName from ThisTable where aName = 'Fred'"

    When run in Query Analyzer, it returns one record (as expected).  When run in code, if returns no records (EOF and BOF are true).  

    When we run a similar query ("....where aName = 'Jonesy'"), it correctly returns the one record in code and in Query Analyzer.  Note that this query is built in the same area as the original (except for the change of the value).

    Any thoughts????

    Allan

  • February 26, 2004 at 11:50 am

    #495955

    DO NOT BOTHER WITH THIS PROBLEM.

    It was another developer's - He loaded a copy of the database onto his machine for testing.  When he looked at the data via Query Analyzer, he could see the record - because he had added it to his copy of the db.  His program was using a DSN which still pointed to the database on the server - which did not have that one record. 

    Sorry if anyone was still trying to find the error.

    Thanks anyway.

    Allan   

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply