- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: SELECT command, condition specific Date Time
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2007 11:09 PM
тАО11-18-2007 11:09 PM
SELECT command, condition specific Date Time
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2007 11:51 PM
тАО11-18-2007 11:51 PM
Re: SELECT command, condition specific Date Time
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2007 12:09 AM
тАО11-19-2007 12:09 AM
Re: SELECT command, condition specific Date Time
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2007 12:48 AM
тАО11-19-2007 12:48 AM
Re: SELECT command, condition specific Date Time
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2007 12:51 AM
тАО11-19-2007 12:51 AM
Re: SELECT command, condition specific Date Time
Per chance I just stumbled into a topic askinf about Mercury forums:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1177230
Hein.