VC++ SQL error......

[noaaprogrammer]

I am getting an "Invalid descriptor index" error when I run the following query in VC++.

select translate(raw_message, chr(0), chr(7))raw_message from raw_data where payload_message_id='46069' and measurement_date=to_date('2004050315','YYYYMMDDHH24')

This query runs just fine in SQL Plus. Does VC++ not support the translate() function?

 

[noaaprogrammer]

And this query runs fine in VC++:

select * from raw_data where payload_message_id='46069' and measurement_date=to_date('2004050315','YYYYMMDDHH24')

 

[Cagliostro]

VC++ doess not supporrt any SQL functions

Ion Filipski

 

[noaaprogrammer]

I figured it out. When I created the database class using the '*', VC++ created objects for all of the columns. In my query that only selected one of those columns, VC++ couldn't find the data to fill all of the database objects, so the error was a result. I added all of the columns to my query, and it works fine now.

 

[noaaprogrammer]

And, yes, VC++ DOES support SQL functions. Translater() included.

 

[Cagliostro]

So, what is the problem now?

Ion Filipski

 

[noaaprogrammer]

There is no problem. As I said, it works fine now.