I have searched the web for many hours and have not found a clear example of how a VB6 program can access a VFP9 DB to Reindex or Create new Indexes on existing tables. Using vfpoledb I have been able to Delete, Insert, Update, & Pack. Since REINDEX is not supported in vfpoledb I need a solution.
Research indicates that using a .prg file may be a viable solution but here is my question on that:
1) Does the .prg need to be compiled and be a member of the existing DBC or can it be created and be used by e.g. connection.execute "DO main.prg"?
2)Does a different driver need to be used in reference to send the command? I would like to publish a complete solution for those that have been seeking this in the past. Foxpro makes an ideal backend DB for VB and Net applications if we could only get past some the questions that have not been clearly addressed in MSDN.
After dropping controls on a panel, each control is assigned an index which is panel1.controls.item(x).After the controls are dropped on the panel, is it possible to re-index the controls via code?
i am having trouble putting a value in a textbox. Each time a ticket is sold i put the total price in a textbox, each time a ticket is sold for the same concert it increases by adding its self to the total price. It works at the first sale, but after that it breaks down. here is the code
Private Function DisplayMoneyTaken() As Integer Dim totalMoney As Integer 'open the database connection
What im trying to do is send vars to a flash file.The following is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim oTitle As New ArrayList Dim oSub As New ArrayList Dim oRate As New ArrayList
[code]....
What I'm expecting the output to display is something like "t1=value&s1=value&r1=rate&t2=value&s2=value&r2=rat&t3=value&s3=value&r3=rat" But... i keep getting this exception: index was out of range. must be non negative and less than the size of the collection. Parameter name: INDEX.
I have a datagridview, with 3 columns, each containing dropdown filters (in the column header). Of the 3 columns, 2 are working perfectly fine, but whenever I try to filter the 3rd column, it gives me this error: (Also all of the column's have the ColumnType property set to: DataGridViewAutoFilterTextBoxColumn) "Index was out of range. Must be non-negative and less than size of the collection. Parameter name: index." The error points to the part that begins with "If dgv1.Rows(e.RowIndex)..."
Private Sub dgvWPS_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv1.CellFormatting If e.ColumnIndex = 1 Then
i am trying to get the value into the cur_stock where item_id = datagrdiview.curentcell.value.I am lookin out for the solution since couple of days, but couldnt figure it out.Well, m trying to make this work on CellMouse click event
Below is my vb.net code:
Private Sub DataGridView_stockout_CellMouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView_stockout.CellMouseClick Dim i As Integer = Stock_checkDataSet1.Tables(0).Rows.Count - 1
Trying to input a high setpoint, low setpoint, a % load, and number of compressors, then calculate the temp that all compressors are off. Then build a datagridview with the staging of compressors from all off to all on for each compressor up to 10 compressors.I am trying to insert headers from 1 to 10 compressors (Variable) with the text "Comp1", "Comp2", etc....Two rows with header. I am trying to use an array with index number to insert the text, but that is where my problem happens."Index was out of range".Here is my code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim i As Integer, num1, num2, num3, num4, alloff As Single, stg As Single TextBox1.Focus()[code].....
I've got the web browser with tabs in all working fine, but there's one bug, i can add tabs, delete em, etc.. but when i delete a tab then go to create a new tab, it gives me the error: InvalidArgument=Value of '6' is not valid for 'index'. Parameter name: index '6' is the number of tabs i had open.Here's the bit of code i use to create the tabs with the browser in it:
vbcode
Dim browse As New WebBrowser browse.Name = "b1" browse.Dock = DockStyle.Fill
I am coding a program for a movie trivia game that randomly shows a movie quote and the the user selects a movie name from a combo box that matches. I used a array for the movie quotes and a comboBox for the movie names. I have coded a portion of the program but I am stuck on how to compare the array quote being shown to what movie the user selects from the comboBox. I have tried numerous different things but none seem to work right. The way I have it coded now it shows that every movie I pick that it is right even if it is wrong. I am going to show part of the code here and also attach the entire solution for anyone that needs it .
I am working in VB 2008 and I have set up a datagridview to display rows of data which can then be selected. When I select the first row I get the error: Index was out of range. Must be non-negative and less than the size of the collection. When I select any other row the program executes as it should. From what I have learned so far is that the DataGridView has an index of -1 and that it counts the header row as part of the index which is the -1.When I select the first row through either DataGridView1_RowHeaderMouseClick or DataGridView1_CellContentClick the index is 0 for the first record. If the index is 0 I think it would fire off, but I have no idea what is happening behind the scenes. I can check the index, so when it is 0 and the code attempts to access the row, that is when I get the message.On an index number of 1 and up the code executes fine.So, is there a way to re-index the DataGridView, or is there a work around/fix for this issue?
How can i get the Column Index and the Row Index when I click on the ListView?The ListView1.FocusedItem.GetSubItemAt(e.X, e.Y).Text function only gets the text of the first column, I can't find the option of getting the Index of the Column and Row upon clicking.
I am running a VB.NET program and having an error of "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".My code looks like below.
If Status.InvokeRequired Then Try Status.Invoke(New delegateoneArg(AddressOf onChangeEvent), ws)[code].....
Im just going to have to get used to this language for the rest of the semester And smohd, I will get back to you with my problem. That "Me..." control is so random. Not like JAVA Why am I getting an error with totalGrade
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
I need to figure out how to index a directory, i know how to get the files in that one folder, but i want to get the sub folders as well then index those. untill there is no more sub folders left and all all the files into a big array. i can do all of that except figure out sub folders. i can get them i just cant figure out how to put it in an array.
I have DataSet "ds", that has a table with two columns and 11 rows. First columns is "ID" second column "name". I need to fill a combo box, with all teh names in "name" column. This i can do with
foreach(DataRow d as ds.Tables[0].Rows){ cmbBox.Items.add(d.ToString());}
But i need to map each name in the combo box to it's "ID" (in the table). Assume ID = 10000 has the name = "Mark", then if the user selects "Mark", i can store it's "ID" 1000 to a variable. How do i map the "ID" to "Name"?PS: Appologies for C# code !
my question is to turn the text in a text box red when it receives focus, and black when it loses focus. I seem to get that "index is out of range" pop-up message. [Code]
I am trying to make a tabbed web browser, on my first tab every thing works fine but on my 2nd 3th etc tabs when i try to do anything type in a url go home refresh anything it says index 0 is out of range perameter name: IndexI am new at Visual basic and i cant find what my problem is.
