Re: Accessing Oracle DB in VC++

This might be way off (or not even help), but the ORDER in which you access the elements matters (or it did for me). Meaning, if you had two fields in a record (like a and b), and A was listed before B in the record, you had troubles accessing B first ,then going back to A.

Maybe?

Joe Drago
jido_at_slip.net

Laurence Maar wrote:

> 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
> - - - - - - --* -- ------ -- *-- - - - - - -
Received on Thu Sep 02 1999 - 00:00:00 CEST