How to push the Database into deadlock state?
What database platform are you using? You’ve listed three different ones in your tags. In general if the database server was in the middle of a deadlock and then failed the parts of the transactions which had been written to the log would be rolled back when the backup system came online. As neither transaction [...]
View Answer
| December 2, 2008 1:56 AM
Database deadlock, Database Failover, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
What database platform are you using? You’ve listed three different ones in your tags. In general if the database server was in the middle of a deadlock and then failed the parts of the transactions which had been written to the log would be rolled back when the backup system came online. As neither transaction [...]
View Answer
| December 2, 2008 1:56 AM
Database deadlock, Database Failover, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server
When calling on innertext values in Visual Basic 2008
I’m not able to test it right now, but I think you could use the Substring method. Something like this: If Link.InnerText.<b>Substring</b>(1,18) = “fight a rock for $” Then Link.InvokeMember(“Click”)
View Answer
| November 29, 2008 1:48 AM
Code, innerText, LINKS, Visual Basic 2008
I’m not able to test it right now, but I think you could use the Substring method. Something like this: If Link.InnerText.<b>Substring</b>(1,18) = “fight a rock for $” Then Link.InvokeMember(“Click”)
View Answer
| November 29, 2008 1:48 AM
Code, innerText, LINKS, Visual Basic 2008
SQL select
You cannot have an outer join as operand of an OR logical operator. For example, if you have a where clause like this: select … from … <b>where <condition_a> <i>OR</i> <condition_b></b> You will get ORA-01719 if either condition_a or condition_b contains an outer join. The action suggested by the documentation is: “If A and B [...]
View Answer
| November 29, 2008 1:21 AM
Oracle development, Oracle SQL, SELECT statement, SQL Query, SQL statements, WHERE statement
You cannot have an outer join as operand of an OR logical operator. For example, if you have a where clause like this: select … from … <b>where <condition_a> <i>OR</i> <condition_b></b> You will get ORA-01719 if either condition_a or condition_b contains an outer join. The action suggested by the documentation is: “If A and B [...]
View Answer
| November 29, 2008 1:21 AM
Oracle development, Oracle SQL, SELECT statement, SQL Query, SQL statements, WHERE statement
MSHFlexGrid vb6.0
If you want to sort the data in the FlexGrid, then you should use the <i>col</i>, <i>colsel</i> and <i>sort</i> properties of the control. If you want to get the data sorted from the data source (DataEnvironment), then I think you would need to modify the command text property of the command object. Assuming that you [...]
View Answer
| November 28, 2008 7:35 PM
MSHFlexGrid, VB, VB 6.0, Visual Basic Sorting
If you want to sort the data in the FlexGrid, then you should use the <i>col</i>, <i>colsel</i> and <i>sort</i> properties of the control. If you want to get the data sorted from the data source (DataEnvironment), then I think you would need to modify the command text property of the command object. Assuming that you [...]
View Answer
| November 28, 2008 7:35 PM
MSHFlexGrid, VB, VB 6.0, Visual Basic Sorting
Amending a Product Price without altering existing orders in Microsoft Access
It is a little difficult to figure that out, since we don’t know how the data is being stored (tables, fields, etc..) and manipulated (inserted, updated, etc…), but from the description of the problem, I think the VAT rate and totals are not being stored in the orders table, and they are being calculated using [...]
View Answer
| November 28, 2008 7:06 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
It is a little difficult to figure that out, since we don’t know how the data is being stored (tables, fields, etc..) and manipulated (inserted, updated, etc…), but from the description of the problem, I think the VAT rate and totals are not being stored in the orders table, and they are being calculated using [...]
View Answer
| November 28, 2008 7:06 PM
Access 2000, Database programming, Microsoft Access, Microsoft Access 2000, Northwind sample database, VAT, Windows XP
how do i select last id in list box and perform a click
The “length” property sets or retrieves the number of objects in a collection, in this case the “links” collection, so the last link will be the link at the position <i>length </i>- 1. So I think you could use something like this: <pre>WebBrowser1.Document.Links(WebBrowser1.Document.links.length – 1).InvokeMe…</pre>
View Answer
| November 28, 2008 6:17 PM
Visual Basic, Visual Basic 2008, Visual Basic List Box
The “length” property sets or retrieves the number of objects in a collection, in this case the “links” collection, so the last link will be the link at the position <i>length </i>- 1. So I think you could use something like this: <pre>WebBrowser1.Document.Links(WebBrowser1.Document.links.length – 1).InvokeMe…</pre>
View Answer
| November 28, 2008 6:17 PM
Visual Basic, Visual Basic 2008, Visual Basic List Box
Extranet login page
Create a login page is not a big deal if you know a little about web programming, but you can become very confused if you are not usual with dot.net. You can try to follow the indications in this link:} http://msdn.microsoft.com/en-us/library/ms178331(VS.80).aspx; let us know if you need more help. Regards
View Answer
| November 28, 2008 6:17 PM
ASP.NET membership, ASP.NET Role Management, Extranet, IIS, Private networks, Web development
Create a login page is not a big deal if you know a little about web programming, but you can become very confused if you are not usual with dot.net. You can try to follow the indications in this link:} http://msdn.microsoft.com/en-us/library/ms178331(VS.80).aspx; let us know if you need more help. Regards
View Answer
| November 28, 2008 6:17 PM
ASP.NET membership, ASP.NET Role Management, Extranet, IIS, Private networks, Web development
Get Image from webcam
This is not a hard thing to do. We are going to use some functions from USER32 and avicap32.dll, so the first thing is to declare them. <pre>Private Declare Function SendMessage Lib “USER32″ Alias “SendMessageA” (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long Private Declare Function [...]
View Answer
| November 28, 2008 5:54 PM
VB 6, VB 6.0, VB 6.0 Image Capture, Webcam
This is not a hard thing to do. We are going to use some functions from USER32 and avicap32.dll, so the first thing is to declare them. <pre>Private Declare Function SendMessage Lib “USER32″ Alias “SendMessageA” (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long Private Declare Function [...]
View Answer
| November 28, 2008 5:54 PM
VB 6, VB 6.0, VB 6.0 Image Capture, Webcam
abort query handle 0001 is invalid
Yes, me!!!! I only see it after a refresh of a workbook and only when I go to close it…. I am leaning towards it being due to version conflict (ie workbook created on older version than using to open it), did you manage to get to the bottom of it?
View Answer
| November 28, 2008 2:14 PM
BEx, Query
Yes, me!!!! I only see it after a refresh of a workbook and only when I go to close it…. I am leaning towards it being due to version conflict (ie workbook created on older version than using to open it), did you manage to get to the bottom of it?
View Answer
| November 28, 2008 2:14 PM
BEx, Query
Can you suggest a load testing tool which is freeware?
This link might be helpful for you… http://searchsoftwarequality.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid92_gci1278511,00.html# Good luck!
View Answer
| November 28, 2008 12:31 AM
.NET, Load testing tools, PHP
This link might be helpful for you… http://searchsoftwarequality.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid92_gci1278511,00.html# Good luck!
View Answer
| November 28, 2008 12:31 AM
.NET, Load testing tools, PHP
Finding the 3rd highest in the table using SQL.
If you want to look for the third highest SAL, this query could do the trick. <pre>select * from Employee E where 2 = (select count(distinct sal) from Employee where sal > E.sal);</pre> I think it should exist another way to do it, but this was the first thing that came to mind. ——————————————————-
View Answer
| November 27, 2008 4:03 PM
SQL Database, SQL Query
If you want to look for the third highest SAL, this query could do the trick. <pre>select * from Employee E where 2 = (select count(distinct sal) from Employee where sal > E.sal);</pre> I think it should exist another way to do it, but this was the first thing that came to mind. ——————————————————-
View Answer
| November 27, 2008 4:03 PM
SQL Database, SQL Query
SQL Query
Please provide information about your table(s) and database, so we can better help you.
View Answer
| November 27, 2008 2:38 PM
SQL, SQL Query
Please provide information about your table(s) and database, so we can better help you.
View Answer
| November 27, 2008 2:38 PM
SQL, SQL Query
Mainframe quality assurance testing tools
If you are testing data entry, Have a look at WinRunner. Dont know the cost, but a good testing tool for mainframe as well as GUI based applications. ******************************* it is important to know which development tools have been used to build this insurance application. the testing is required for application and not for the [...]
View Answer
| November 27, 2008 8:31 AM
390, Automated, Billing and customer care, Billing Support Systems, DB2, Development, Functional, IBM, Lifecycle development, Mainframe, Performance/Load, Project management, Software testing, Software testing tools, Systems management software, Training, Web, zSeries
If you are testing data entry, Have a look at WinRunner. Dont know the cost, but a good testing tool for mainframe as well as GUI based applications. ******************************* it is important to know which development tools have been used to build this insurance application. the testing is required for application and not for the [...]
View Answer
| November 27, 2008 8:31 AM
390, Automated, Billing and customer care, Billing Support Systems, DB2, Development, Functional, IBM, Lifecycle development, Mainframe, Performance/Load, Project management, Software testing, Software testing tools, Systems management software, Training, Web, zSeries
VB Registry Value reader
<pre>strRegValue = “” GetStringValue(HKEY_LOCAL_MACHINE, “SOFTWAREMicrosoftKEY”, “Path”, strRegValue) If strRegValue <> “” Then <do something> End If </pre>
View Answer
| November 27, 2008 1:26 AM
Registry, VB, VB Registry Value
<pre>strRegValue = “” GetStringValue(HKEY_LOCAL_MACHINE, “SOFTWAREMicrosoftKEY”, “Path”, strRegValue) If strRegValue <> “” Then <do something> End If </pre>
View Answer
| November 27, 2008 1:26 AM
Registry, VB, VB Registry Value
Multiple image swap onclick – the main image and thumbnail to show ‘selected’
In your script function after <script type=”text/javascript”>, add the following code. These are functions I’ve created so it will first clear all the dark blocks, then add the dark block to the specified location, then change the image. <pre>function doBoth(objNameChg,imgNameChg,imgSrcChg,imgSrcGrey){ clearpic(imgSrcGrey); movepic(imgNameChg,imgSrcChg); changeIt(objNameChg); } function clearpic(imgSrcClr){ document.button1.src=imgSrcClr; document.button2.src=imgSrcClr; document.button3.src=imgSrcClr; document.button4.src=imgSrcClr; document.button5.src=imgSrcClr; document.button6.src=imgSrcClr; document.button7.src=imgSrcClr; document.button8.src=imgSrcClr; document.button9.src=imgSrcClr; [...]
View Answer
| November 27, 2008 1:21 AM
ASP, JavaScript, VBScript
In your script function after <script type=”text/javascript”>, add the following code. These are functions I’ve created so it will first clear all the dark blocks, then add the dark block to the specified location, then change the image. <pre>function doBoth(objNameChg,imgNameChg,imgSrcChg,imgSrcGrey){ clearpic(imgSrcGrey); movepic(imgNameChg,imgSrcChg); changeIt(objNameChg); } function clearpic(imgSrcClr){ document.button1.src=imgSrcClr; document.button2.src=imgSrcClr; document.button3.src=imgSrcClr; document.button4.src=imgSrcClr; document.button5.src=imgSrcClr; document.button6.src=imgSrcClr; document.button7.src=imgSrcClr; document.button8.src=imgSrcClr; document.button9.src=imgSrcClr; [...]
View Answer
| November 27, 2008 1:21 AM
ASP, JavaScript, VBScript
use 32gb ram with oracle 10g and windows 32bits
32-bit windows will not support anything more than 4GB of RAM. You will have to upgrade to a 64-bit platform. *********************************************** For more information about the maximum amount of memory that a 32 bit windows sytem will support check <a href=”http://www.vistaclues.com/reader-question-maximum-memory-in-32-bit-windows-vista/”>here</a>. Acording to this site it is right around 3GB. Good Luck! -Flame
View Answer
| November 26, 2008 11:08 PM
Oracle 10g, Win32
32-bit windows will not support anything more than 4GB of RAM. You will have to upgrade to a 64-bit platform. *********************************************** For more information about the maximum amount of memory that a 32 bit windows sytem will support check <a href=”http://www.vistaclues.com/reader-question-maximum-memory-in-32-bit-windows-vista/”>here</a>. Acording to this site it is right around 3GB. Good Luck! -Flame
View Answer
| November 26, 2008 11:08 PM
Oracle 10g, Win32
Excel macro between worksheets
Hi Adavidson, hope this macro code solves ur problem ‘***************************************************************************************************** Sub test() Dim l, m As Long Dim i, j As Long Sheets(“Outstanding”).Activate Cells(1, 1).Activate ‘l used to find the last used cell in a column & the message box will display the No.of used cells in the File number column l = Cells.Find(What:=”*”, After:=<a1], [...]
View Answer
| November 26, 2008 10:21 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
Hi Adavidson, hope this macro code solves ur problem ‘***************************************************************************************************** Sub test() Dim l, m As Long Dim i, j As Long Sheets(“Outstanding”).Activate Cells(1, 1).Activate ‘l used to find the last used cell in a column & the message box will display the No.of used cells in the File number column l = Cells.Find(What:=”*”, After:=<a1], [...]
View Answer
| November 26, 2008 10:21 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel
Display different fields in VB Data Report
If you really mean different <i>fields</i>(not different records), I think you will need to dynamically change the command text of the query. I don’t know how you are going to design the form to let the user choose what information to see, but for this example, I will assume that you have two buttons, one [...]
View Answer
| November 26, 2008 8:01 PM
Database programming, DataEnvironment, VB, VB Data Report, Visual Basic
If you really mean different <i>fields</i>(not different records), I think you will need to dynamically change the command text of the query. I don’t know how you are going to design the form to let the user choose what information to see, but for this example, I will assume that you have two buttons, one [...]
View Answer
| November 26, 2008 8:01 PM
Database programming, DataEnvironment, VB, VB Data Report, Visual Basic
Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.
Hi, Try this :- =CONCATENATE(“*”;A2;”*”) Regards, Martin Gilbert. ================== or ==(“*”&A2&”*”)
View Answer
| November 26, 2008 5:20 PM
Excel 2003, Excel formulas, Microsoft Excel
Hi, Try this :- =CONCATENATE(“*”;A2;”*”) Regards, Martin Gilbert. ================== or ==(“*”&A2&”*”)
View Answer
| November 26, 2008 5:20 PM
Excel 2003, Excel formulas, Microsoft Excel
I want to retrieve always the first record via sql
An example of the data you want to get from the query would have been nice. If you just want to get the date of the first sold article, for every different article, a query like this should do the trick: <pre>Select article_id, min(sale_date) From sales Group by article_id</pre> As we don’t know your column [...]
View Answer
| November 26, 2008 4:41 PM
SQL, SQL Database, SQL Record
An example of the data you want to get from the query would have been nice. If you just want to get the date of the first sold article, for every different article, a query like this should do the trick: <pre>Select article_id, min(sale_date) From sales Group by article_id</pre> As we don’t know your column [...]
View Answer
| November 26, 2008 4:41 PM
SQL, SQL Database, SQL Record
