MS SQL Server ODBC - SQL_NEED_DATA During ODBC Query

Author

SQL_NEED_DATA During ODBC Query

Reuven Nisser

2006-01-09, 7:23 am

Hello,
I am using MFC 6.0 CRecordset to access data inside an SQL Server table
TEMPORARY_DATA. The table contains also a BLOB field.

The query I am using is:
SELECT * FROM TEMPORARY_DATA WHERE
TD_DESTINATION_ID='0
5101' AND TD_PLAN_DATE < {ts '2006-01-09 00:00:00'}
AND TD_PLAN_DATE >= {ts '2006-01-07 00:00:00'} AND TD_PLAN_DATE_END >
{ts '2006-01-08 00:00:00'} AND TD_STATUS<>'P' AND TD_STATUS<>'X' AND (ID
like '75%'))

I receive SQL_NEED_DATA error. I do not know exactly where it happens.
Maybe during Open() or MoveNext().

When using standard CRecordset programming with variables loaded
automatically from the record to program variables, how should I handle
such a problem?

Thank you,
Reuven Nisser

Steven Cheng[MSFT]

2006-01-10, 3:23 am

Hi Reuven,

Thanks for your posting.
Regarding on this issue, I've also noticed your another duplicated thread
posted in this newsgroup.
I've posted my response there and if you feel it convenient that we
continue to discuss in that one, please feel free to post there.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Date: Mon, 09 Jan 2006 13:05:58 +0200
| From: Reuven Nisser <rnisser@newsgroup.nospam>
| User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
| X-Accept-Language: en-us, en
| MIME-Version: 1.0
| Subject: SQL_NEED_DATA During ODBC Query
| Content-Type: text/plain; charset=ISO-8859-8-I; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <utXgvyQFGHA.1816@TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: dsl217-132-219-253.bb.netvision.net.il 217.132.219.253
| Lines: 1
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.odbc:44613
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hello,
| I am using MFC 6.0 CRecordset to access data inside an SQL Server table
| TEMPORARY_DATA. The table contains also a BLOB field.
|
| The query I am using is:
| SELECT * FROM TEMPORARY_DATA WHERE
| TD_DESTINATION_ID='0
5101' AND TD_PLAN_DATE < {ts '2006-01-09 00:00:00'}
| AND TD_PLAN_DATE >= {ts '2006-01-07 00:00:00'} AND TD_PLAN_DATE_END >
| {ts '2006-01-08 00:00:00'} AND TD_STATUS<>'P' AND TD_STATUS<>'X' AND (ID
| like '75%'))
|
| I receive SQL_NEED_DATA error. I do not know exactly where it happens.
| Maybe during Open() or MoveNext().
|
| When using standard CRecordset programming with variables loaded
| automatically from the record to program variables, how should I handle
| such a problem?
|
| Thank you,
| Reuven Nisser
|

Sponsored Links