183 Posted Topics
 | Just a few observations: 1) *index* and *count* appear to generally have the same value. Is there a need to have two variables? 2) Change the condition from **<** to **<=** so that the loop can continue after the existing limts of the array. 3) I do not see how …  |
| | See if putting **DISTINCT** in the **SELECT** statement helps.  |
| | `If 0 <= a <= 100 Then` This compares 0 and a, which gives a boolean result. This boolean is then compared to 100, which it will be less than. Therefore the condition is always true and will always be executed, no matter what the value of a is. `If … |
| | Your code will give a result of 0, because the letters *a* nor *b* are present in the given string. If you want to see if a particular character is a letter look at the `IsLetter` function. |
| | In the validation code for each textbox, make sure the text is well-formed. If it is, store the value in a module-level private Integer value. If not, cancel the validation, forcing the user to enter a valid value. Allow an empty field, which loads the module-level variable with 0. In … |
| | In line 8, you declare that the function is to return a *double*, but you do not return a value in your function. At the end of the function, return a double or change the return type of the function. public static int Largest() { Scanner s = new Scanner(System.in); … |
| | **Not Tested** strSQL = _ "SELECT * FROM tblName WHERE Format(fldDate, ""Mmmm"") LIKE '%" & _ textbox.text & "%'" This kind of construction was often valid in VB6. I have not tried it in VB.Net. |
 | The elements of Pascal's triangle are the statistical combination of the given row and column, if you consider Pascal's triangle as a right triangle. 1 1 1 1 2 1 1 3 3 1 1 4 6 4 1 ... Each element of Pascal's triangle is the result of nCr, … |
| | The big clue is in the message "The file you are trying to open .xls is in a different format than specified by the file extension." The filename should appear, not just the extension. Open the file you want to import into a text editor. Is it actually a delimited … |
| | Re: majority element Your *for* loop starting at line 5 will never be executed. You have the wrong condition. You need to reset *c* to 0 at the start of each main loop. At line 6, put `c=0;` You do not have to initalize *c* because it is getting reset right away. I … |
| | Lines 30 and 31 are not needed because the variables get set at the beginning of the For-Loop. Is the function being called at all? Help() might have a name conflict. Put a breakpoint after the last Dim statement and try calling this Sub. See what happens. |
 | You need some whitespace before the WHERE clause. Do you need to use LIKE in your WHERE clause? This could be a lot faster if you used an equality test. Especially if you have an index (or even better, primary key) on **Minsters.User_Name**. Your comparison is against users who already … |
| | In VB.Net, use ADO.Net to dynamically connect to your MS-Access database. Walk trough the tables and fields using `For Each` loops. Now send the data to the MySQL database. The are a couple of ways you can connect to a MySQL database using VB.Net. The first is to use the … |
 | Look at the **EXPLAIN** command. It will tell you what steps the MySQL engine would take to execute a given SELECT statement. [MySQL Documentation](http://dev.mysql.com/doc/refman/5.0/en/explain.html) |
| | There are lots of mechanisms for connecting to a Unix server. What kind of connection do you want to establish? FTP, SFTP, Telnet, SSH, NFS, SAMBA file access, SSHFS, etc. Each protocol behaves a little differently. |
| | I think the problem is in line 11 of your revised code. Your **for** loop is `for (int i = 0; i < 1; i++)`, when it needs to be `for (int i = 0; i < 10; ++i)`. The value in the condition is **10** not the **1** you … |
 | @Justin: You have to watch out when you use automated translator software. Sometimes they can give phrases that do not make sence to native speakers, if the termns you used didn't quite make sence from the point of view of the people writing the translation software. Where Justin said **Visual … |
| | What might be more useful is to make a function that generates all the Armstrong numbers in a given range.  |
| | Part of the design of Java is that it runs in a virtual machine and everything that a Java program (applets, etc.) does happens within that virtual machine. This means that a Java program should not be able to run another application that is not also part of the same … |
| | In VB6, the **Date** type would automagically convert back and forth to a floating-point number, with the integer part representing the day, and the fractional part representing the part of the day (hours, minutes, etc.). When you subtracted a number from a date, you were relying on this behaviour. Pushing … |
| | Down at the bottom of the screen is a series of links; one is labelled **Unanswered**. When I click on it, I see **Unanswered Articles within My Favorite Forums**. Where do I go to define / refine this list of Favorite Forums? Is it part of my profile?  |
| | There are three functions that can give Date/Time information in VB6: Now (which gives date and time), Date (which gives only the date), and Time (which gives only the time of day). Putting the $ on the end forces the result to be a string instead of a Date type. … |
| | I am pretty new to programming in VB.Net, but I have been programming in other languages for a couple of decades now, including VB5/6 and C++. When I am using a **Try** - **Catch** block to handle exceptions, what is the point of a **Finally** section? Wouldn't it be just …  |
| | From the MSVS 2008 documentation. > Modifications made to the base form at run time have no affect on inherited forms that are already instantiated. If you make changes to the properties in the Designer at design-time, then the changes can be updated in the derived form. Changes made at … |
| | I have noticed that when I first post something, either as a new discussion or as a response to someone else, I can edit what I just posted. When I come back quite some time later, the option to edit is not longer presented. I am wondering how long that … |
| | You could copy and paste the characters from the **Character Map** program under Start - Programs - Accessories - System - Character Map. The exact names for each step will vary depending on your operating system. This program allows you to select pretty much any Unicode character and then copy … |
| | I have recently started coding in VB.Net and started using the Try-Catch style of exception handling available in .Net, which I admit is very similar to the exception handling of C++, so it is not all that unfamiliar. In my VB6 code, which I have been using up till now …  |
| | First of all, this code is VB.Net, not VB6. Please post in the correct forum. That said, you are asking the clock for the millisecond count, which will you an integer from 0 to 999; there is your 3-digit number. Because you are using only 1000 unique seeds, your will … |
| | Re: Simplex Method While the simplex method for optimizing linear system of inequalities can be straight forward, it is not entirely simple. Try working on a few simple systems by hand to get an insight into how the method works and then try defining the method top-down. Start by writing down the major … |
 | Do not include the prompt in the Command you want the Shell to execute. Just start at the **echo** command. You also need to have the **command** be concatenated, not part of the string, as noted earlier. Private Sub Command1_Click() Dim command As String command = "echo Main-Class: ProgressBarStep > … |
| | You need to give a few more details to get a reasonable answer. Please give definitions, with at least the type and what it connects to, of all the variable that you use, including **Ary**, **AryCurrencyValue**, **e**, **y**, **dt**, **dt.Rows(integer).Item(integer)**, **advance**, **advance1**. What is the purpose of **q**? Is it … |
| | WebRequestMethods.Ftp is a wrapper for a client of the FTP Internet service. Some FTP Servers support multiple file deletion with the MDEL command, but some don't. It is possible with the **mdelete** client command to nuke a populated directory, but only if the server allows it. Unfortunately, **mdelete** is not … |
| | The way to think of this is to use an array the size of your expected results that consists of indexes into your original word, then systematically increment the indexes until you have every possible arrangement of the letters. Each index in the array indicates what letter of the original …  |
The End.