I'm currently trying to create a program in VC++ (6.0 Enterprise)
to query my companies DB. I've figured out how to access an entire
record using the CRecordSet base class, however I want to modify the
SELECT statement to narrow down my search since obviously I dont want to
grab the entire database and MoveNext() through the whole damn thing.
I've tried:
PDriver x;
LPCTSTR str = "SELECT A00_PNUM, A06_EDITION, A4V_AGE_LICENSED,
B41_BIRTHDATE, B42_AGE FROM PDRIVER";
x.Open(AFX_DB_USE_DEFAULT_TYPE, str);
where Pdriver is a CRecordSet class and PDRIVER is the table name, but
when I run this code on the call to Open() I get the error:
"Invalid Descriptor Index"
To which I have no idea what this means, nor is the MS Library help
any help along those lines.
Any advice? Thanks in advance.
Laurence
- - - - - - --* LioN !_at_#$%^& *-- - - - - - -
Laurence Maar *** *** **** Home
My loneliness is killing me and I must confess... 805.880.6046 VM-Pager