Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

SELECT command, condition specific Date Time

Marijana_1
Occasional Visitor

SELECT command, condition specific Date Time

Hello all,

Could someone help me with select command?
I want to get all bugs as newer as specific date.

While running Execute(), occures "Exception from HRESULT: 0x800403EA". I suposed it is because I'm not good writting select command.
Here is the code which I used.

TDConnectionClass td = new TDAPIOLELib.TDConnectionClass();
TDAPIOLELib.Command com = td.Command as TDAPIOLELib.Command;
TDAPIOLELib.Recordset recset;
com.CommandText = "select bg_vts from bug where bg_vts > 11/16/2007";
recset = com.Execute() as TDAPIOLELib.Recordset;

Also, THERE IS NO PROPERTY FieldValue()!!!!
recset.FieldValue();

I'm looking forward to hearing from you with advise or help.

4 REPLIES
Hein van den Heuvel
Honored Contributor

Re: SELECT command, condition specific Date Time

Marijana,

Welcome to the HP ITRC forum for OpenVMS.

What operating system are you using?
Is it indeed OpenVMS ?? If so, what version/platform?

This appears to be a DATABASE problem.
What database? What version>

Finally, what programming language /version?

If you execute te same query in an interactive program development tool (SQL worksheet? Toad? SQLdeveloper? iSQL? ), then does it work or not?
The answer will help focus the problem search.

hth,
Hein van den Heuvel

Marijana_1
Occasional Visitor

Re: SELECT command, condition specific Date Time

Thank you for answer!

So, I think that unmatched forum field.
I'm working under Windows XP OS, using Visual Studio C# for programming.
I need to get all bugs newer than set specific date time in SELECT command from Mercury Quality Centre Database.

Could you please recommend me right forum name.

Thanks in advance for any help.
Hein van den Heuvel
Honored Contributor

Re: SELECT command, condition specific Date Time

Well, the closest Forum here is probably "micorsoft general":

http://forums1.itrc.hp.com/service/forums/categoryhome.do?categoryId=10

However, this problem probably has nothing to do with the system (HP?) or the OS.

I would look for some forum specifi for "Mercury Quality Centre Database." or go straight to support for that.
This sounds way to specific for genric help.

Good luck!
Hein.

Hein van den Heuvel
Honored Contributor

Re: SELECT command, condition specific Date Time

Hmm,

Per chance I just stumbled into a topic askinf about Mercury forums:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1177230

Hein.