Problem with SQL query using Access + ODBC 
Author Message
 Problem with SQL query using Access + ODBC

I'm writing this SQL query "select a,b from TBL"
& i get nothing
it only works correctly when i use * or all the fields of the dbase are ordered corecctly ,but when i dont write all of the fields of the dbase or if i place all of them but not in the order of the dbase then i get nothing from the query.
i'm using a derived class of the CRecodset class.
pls help me :-<

-----------------** -- Posted from CodeGuru -- **-----------------
http://www.*-*-*.com/ ;  The website for Visual C++ programmers.



Fri, 07 Dec 2001 03:00:00 GMT  
 Problem with SQL query using Access + ODBC
Which version of Access do you use?
Please give us some "real" code - SQL statement and CRecordset-derived
class.

Zlatko

Quote:

>I'm writing this SQL query "select a,b from TBL"
>& i get nothing
>it only works correctly when i use * or all the fields of the dbase are

ordered corecctly ,but when i dont write all of the fields of the dbase or
if i place all of them but not in the order of the dbase then i get nothing
from the query.
Quote:
>i'm using a derived class of the CRecodset class.
>pls help me :-<

>-----------------** -- Posted from CodeGuru -- **-----------------
>http://www.codeguru.com/    The website for Visual C++ programmers.



Fri, 07 Dec 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing an Ms Access 2000 Query using VC++, via ODBC

2. Help: Using MFC ODBC classes to access SQL BLOBs

3. Escape codes for SQL filter string using Access with MFC ODBC

4. Escape codes for SQL filter string using Access with MFC ODBC

5. NT Service using ODBC to access SQL Server without MFC

6. Problem Querying Date from MFC to Access through ODBC

7. Wildcard select problem with VC++/ODBC/Access/SQL

8. Wildcard select problem with VC++/ODBC/Access/SQL

9. PROBLEM: Accessing SQL SERVER 6.5 from 16 bit ODBC Application (VC++ 1.5)

10. Problem sorting predefined query using ODBC

11. PROBLEM: Accessing SQL SERVER 6.5 from a VC++ 1.5 ODBC application

12. Help needed: problem in using odbc call to write binary data to SQL Server

 

 
Powered by phpBB® Forum Software