topic Re: SELECT command, condition specific Date Time in Operating System - OpenVMS

SELECT command, condition specific Date Time

Marijana_1 — Mon, 19 Nov 2007 07:09:35 GMT

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.

Re: SELECT command, condition specific Date Time

Hein van den Heuvel — Mon, 19 Nov 2007 07:51:16 GMT

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

Re: SELECT command, condition specific Date Time

Marijana_1 — Mon, 19 Nov 2007 08:09:27 GMT

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.

Re: SELECT command, condition specific Date Time

Hein van den Heuvel — Mon, 19 Nov 2007 08:48:15 GMT

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.

Re: SELECT command, condition specific Date Time

Hein van den Heuvel — Mon, 19 Nov 2007 08:51:35 GMT

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.