Select Query

[jkbiyani]

Hi,
I am fetching a Recordset from Oracle database. The Query is following:
Select to_date(date1,'dd-mon-yyyy'),count(*) from Mytable
group by to_date(date1,'dd-mon-yyyy')

This query can be executed perfectly on Oracle prompt but in VB it produces the following error:
multiple step generated errors. Check each status Value.

Can anyone help me? Why this is so?
Plz reply soon.

[Wokawidget]

I believe it's something to do with the Microsoft Cursor Engine, in fact I am almost 100% sure of it. Not sure how to fix the problem though

Sorry...

You could check this link out:

This link my help you with your query problem

[jkbiyani]

it is still not working .
Plz reply soon.

[djengiz]

I need a little more information. Do you need one or more fields. etc

[jkbiyani]

I want only 2 fields, the date part like '20-DEC-2001' And count of the records for that date. Ok
Now analyze again.

[djengiz]

here is your aswer and dont be so rude in future pall.

SELECT Format(date,"yyyy-mm-dd") as [Date], Count(date) AS CountOfDate
FROM Table
GROUP BY date;

[jkbiyani]

My dear,
Sorry if I hurt your feelings. But as I have tried many combination of this query, I could not execute this query. And again as you wrote:
this query can't be executed on Oracle Prompt. Plz try on Oracle. I have already mentioned that I have to execute this query on Oracle prompt.
So plz help me if you can.

Jitendra

[DaveAMS]

are you using ADO? could you post your vb code?

I assume you've successfully retrieved other recordsets from your oracle database using similar vb code...have you tried doing something like "select * from table"? This would verify that your connection string and other ADO settings are correct.

[djengiz]

Hi,

i dont have an oracle database. but i think your problem is in ADO or your ODBC settings. This query should work. You might want to post the code so i can have better look.

yours

D