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='05101' 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
|
