944,141 Members | Top Members by Rank

Ad:
Oct 4th, 2004
0

Need Help Accessing a Primary key MS Access in SQL to print out informatio.

Expand Post »
I am having problems making my code access the primary key, and to print information out to screen in a C++ program that I Am writing. Need some help PLEASE ! The Primary Key Name is ID1. HERE IS THE CODE

#include <windows.h>
#include <stdio.h>
#include <conio.h>
#include <iostream.h>
#include <tchar.h>
#include "ODBCWrapper.cpp"
//make sure you include the namespace
using namespace std;
using namespace ODBC;

int main(void) {
MDBConnection link;
if(link.Connect("C:\\Documents and Settings\\Chester Mayle\\My Documents\\My Data Sources\\db1.mdb")) {
ODBCStmt Stmt(link);
SQLExecDirect(Stmt, (SQLTCHAR *) _T("USE Foo"), SQL_NTS);
int pos = 1;
TCHAR strQuery[256] = _T("SELECT car1 FROM \ID Data Base\where ID1='2%'");
//t
//tl
//TCHAR strQuery[256] = _T("SELECT * FROM \ID Data Base\"");
//int nRet =
cout<<Stmt.Query(strQuery);
printf("%5d:\tColumns\t%d\r\n\r\n", Stmt.GetColumnCount(), 0);
string cg;
//SELECT [ID1] FROM [ID Data Base] where ID1='2%'";

while(Stmt.Fetch()) {
ODBCRecord rec(Stmt);
//printf("Row %5d\r\n", pos);

INT i = 0;
while(i < Stmt.GetColumnCount()) {
TCHAR Desc[512] = _T("");
SQLINTEGER cbDesc = 0;
rec.GetData(i + 1, Desc, sizeof(Desc), & cbDesc);
//TCHAR Name[256] = _T("");
TCHAR Name[256] = _T( "WHERE ID1=2%");
rec.GetColumnName(i + 1, Name, sizeof(Name));
i++;
printf("\t%15s\t\\>\t%25s\r\n", Name, Desc);

}
pos++;
};
}
else {
printf("Connection failed.");
}
link.Disconnect();
//getch();
char asd;
cin>> asd;
return 0;
}
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Chester1 is offline Offline
11 posts
since Sep 2004
Oct 4th, 2004
0

Re: Need Help Accessing a Primary key MS Access in SQL to print out informatio.

isn't the problem the fact that you have not selected ID1 in your SQL statment?

Quote ...
TCHAR strQuery[256] = _T("SELECT car1 FROM \ID Data Base\where ID1='2%'");
try select ID1,car1 from blah blah....
Reputation Points: 10
Solved Threads: 0
Newbie Poster
clartsonly is offline Offline
15 posts
since Oct 2004
Oct 4th, 2004
0

Re: Need Help Accessing a Primary key MS Access in SQL to print out informatio.

also I think the first column is 0 not 1
in your loop you reference i + 1 which will start with 1 not 0.

Quote ...
rec.GetData(i + 1, Desc, sizeof(Desc), & cbDesc);
//TCHAR Name[256] = _T("");
TCHAR Name[256] = _T( "WHERE ID1=2%");
rec.GetColumnName(i + 1, Name, sizeof(Name));
Reputation Points: 10
Solved Threads: 0
Newbie Poster
clartsonly is offline Offline
15 posts
since Oct 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: how to create db of correspondence in access
Next Thread in MS Access and FileMaker Pro Forum Timeline: How to export excel data to a search engine?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC