SQL Keys Acting A Little Strange?
Jun 15, 2011
I have a bit of a strange problem with MySQL that I've never seen before. Basically, I need to enter the same entry into a table x number of times. The Primary Key is auto increment so there shouldn't be any duplicate value problems. However, it takes the last few columns and seems to clump them all into one value and is using that as a key. The error I'm getting back is:Duplicate entry '80-0--2011-06-16-0-1' for key 'idx_mtind you, there is no field called idx_mt. The primary key field is called just ID. And that 80-0--2011-06-16-0-1 is the last 8 columns or so (which you can see the names of in the cols variable) concatenated, which they obviously shouldn't be doing. Also, the first time the loop runs through, the entry goes through, but the later ones conflict with it. I confirmed that this is the problem by changing one of the last 8 columns to a value based on a loop, and that went through with no problems.
Dim cols As String = ""
Dim msi As System.Globalization.DateTimeFormatInfo = New System.Globalization.DateTimeFormatInfo()
[code]...
View 1 Replies
ADVERTISEMENT
Oct 21, 2008
I have a problem detecting whether one of the arrow keys is pressed, all the other keys seem to be detected apart from the arrow keys??? I have set key preview to True........ It detects the arrrow keys BUT ONLY if I have NO other controls on the form??? example..
Me.Text = e.keycode
It works, but then if I add a button for example, it stops.
View 3 Replies
May 30, 2011
I have a problem with an MD5-hash algorythm that's acting very oddly.Here's the
vbcode
Imports System.Security.Cryptography
Imports System.Text
[code].....
View 2 Replies
Apr 21, 2011
I stumbled upon something i don't quite see the logic of. Let's ork with following piece of code:
For Each ds As DerivedScale In List
If ds.ScaleID = scaleId Then
ds.ScaleID = ds.ScaleID + scaleStep
[Code].....
This piece is written for 2 records to change place and change the sequence number (scaleid). The arrow indicates where the issue occurs. The item "ds" is replaced by the object 1 indexnumber higher/lower. This does however not effect that object in the List. So when i check, item ds isn't set.
However, when i look at ds.ScaleId = ds.ScaleID + scaleStep, this is reflected in the List.
So what I am wondering is: is "ds" acting like a local variable here, and can i only make changes to it's properties?
View 4 Replies
Nov 29, 2011
I have an application that uses bound controls on the form. I have a dataset associated with my form and have a custom query written for one of my tables that is supposed to get two fields in the database and order them by their ID in descending order. However, when I run the program, the bound controls do not contain the last record, but the first.
View 8 Replies
Jul 13, 2009
part 2 of 2: i was just wondering, is anyone else experiencing problems with their webbrowser, as in not displaying the right side links properly, and the reply, always sends you to an off screen, with no edit options, or being able to insert code in. this is currently happening in my firefox browser, although the i.e.8 has no problems... just want to know, to see if maybe it is a bug with my firefox, or they are again, updating the forum.
[Code]...
View 9 Replies
Nov 29, 2010
I'm trying to add items to the listview, but ever time i add a icon the Listview freezeslinks a white color for a millisecond.A millisecond is not a lot, but when you add 5 items per second to the listview then all you see is a white shade blinking. I tried slowing the thread down so it takes longer for it add the items still no luck.
View 5 Replies
Nov 4, 2010
Will the elements in myList always be visited in the same order with a For Each loop (assuming I don't alter the list)?
Dim myList As New List(Of MyElement)
....
For Each myElem As MyElement In myList
' yadda yadda yadda
Next
View 1 Replies
Jun 20, 2010
I have a software under contruction for a small firm. And it requires email functionality. That is, whenever the users in the main database reaches the payment date, an email will be send to that user as a reminder.Or, in certain period, the admin needs to send a notification mail to all the users in the main database.
So, how can I incorporate that facility in my main app ?My present idea is to create a separate app for send the mails. That is, when the admin compose the mail and selects a bunch of users (as recipients) from the database, all the message will be saved to another database (for mailing application) and will start the mailing app. This mailing app will check it's database for any pending emails to be sent, and if there exists any pending mails, it will start sending one by one. After sending each mail, it will remove that from the database.
What's your idea ? Does it sounds ok to you I don't want the user of my main app to know that there exist another program, running in background, sending emails.
View 13 Replies
Jun 25, 2011
just wondering how i could give my auto typer hot keys, for example they press f1 to start the typer f2 to stop it.
[Code]...
View 4 Replies
Mar 25, 2011
I'm trying to create a shortcut which expands or collapses my treeview using the ctrl+alt+up-arrow or ctrl+alt+down-arrow:
If Keys.ControlKey And e.KeyCode = Keys.Alt And e.KeyCode = Keys.Down Then
mytreeview.ExpandAll()
End If
[code].....
View 2 Replies
Jun 27, 2010
i have the following code
Dim url1 As String
url1 = "www.google.com" & GWP_NodeList.Item(i).SelectSingleNode("icon").Attributes("data").InnerText
Dim webClient As New System.Net.WebClient
Dim bytes() As Byte = webClient.DownloadData(Url)
[code]....
I get this error:
Could not find a part of the path 'D:UsersGlenn RuysschaertDocumentsVisual Studio 2008ProjectsUITestUITestinx86Debugwww.google.comigimagesweathersunny.gif'.
How on earth did it all of a sudden add the startuppath to my url?
View 3 Replies
Oct 12, 2010
I'm having some difficulties chopping up a word document. I think the problem may be that it's 900+ pages, but I'm not completely sure.The separate documents within the document file are separated by x of 100 documents. I'm trying to split at the "of 100 documents", however when I try to split the string that I put this word document's contents into, it will only split with the first letter I give. So, when I try to split it by "of 100 documents", it will only split by "o".
View 1 Replies
Apr 9, 2012
I created a simple custom controlled Panel for double buffering. When I use the control in my toolbox it works just fine, but when I attempt to add controls inside the panel those controls aren't staying when I move the panel around. My custom panel isn't acting as the controls' parent. I verified this by looking in the designer code.
I tested a standard panel on the same form and it works perfectly normal - as I drag the parent Panel the interior controls move along with it. It is only my custom Panel which doesn't seem to detect when another control is placed within it.
Here is my constructor
Public Class DBPanel
Inherits System.Windows.Forms.PictureBox
Public Sub New()
[Code].....
View 8 Replies
Jan 13, 2011
How could I loop through a list of the keys that are available in the 'Keys' enumeration? It seems like it should be something easy to do, but I'm not having any luck finding a collection that I can loop through.
View 6 Replies
Mar 17, 2009
Am devloping an application with multiple forms, which reside on top of a main form. i.e the main application window. The 'child' forms do not need to be linked in any way as they do not pass information to the parent form, as all the parent form does is act as main window.Now I would like to know what is the correct way for the 'main window' form acting as a container for the other forms? So that all the smaller secondary forms stay focused on top of the main application form, that when the main window is minimized, so these forms should do also etc..
I have read other posts and they mention, leaving all the forms standard i.e. IsMdiContainer = False and then using form.showDialog() to call the secondary forms. This did not work for me as what happens is that as soon as I give focus to the main app form, the secondary form disappears underneath.I tired making the main app form IsMdiContainer = True and when it loads calling:
frmMemberForm.MdiParent = Me
Now this works, because I can click off the form and minimize the app etc and the frmMemberForm doesn't disappear. However if i close the MemberForm and reopen it, it looses this property and once again when it looses focus, it will disappear.
View 16 Replies
Aug 11, 2011
Module Module1 Public Declare Function GET_CALCULATION_FAN_ALONE Lib "EbmPapstFan.dll" (ByRef path As String) As Long Private Declare Function GET_PRODUCTS Lib "ebmpapstfan.dll" (ByRef path As String) As Long Public Declare Function SET_XML_PATH Lib "EbmPapstFan.dll" (ByRef path As String) As Long
[Code]...
View 2 Replies
Feb 9, 2011
i was wondering if it possible to have a condition where lets say you have a column in the datatable called amount and a textbox acting as the filter called say maxamount to set it so the rowfilter when filtering the table will sum the number in the amount column until the number in maxamount is met, then stop and only return the rows where the total sum of the amount column is equal or less than the maxamount value, so i guess if the next row takes us over the maxamount it discards this row and returns the rows previous to it. is this possible using datagridview rowfilter or should i be loooking elsewhere to achieve this?
View 4 Replies
May 23, 2010
So I found this little morpg. The game is fun but really repetitive. I would like to simplify some of the tasks in the game. I do not know how to start this project. How can I recored arrow keys and then tell the computer to enter the arrow keys? One of the objectives in the game is to run around a farm 2x and scare away any wolfs. So the commands would be "arrow key up" for 30sec and then "arrow key right" for 4 sec and repeat. I have worked with robots in real life for some time. We would fill arrays with such instructions. One of the most fun things to program! But I have no idea how to do this in VB.
View 12 Replies
Mar 15, 2010
I'm exporting a table of data to CSV format, e.g.:
"COL1","COL2","COL3"
"1","some text", "£232.00"
"2","some more text", "£111.00"
"3","other text", "£2.00"
The code to export is fairly simple using an ashx handler:
[Code]...
My issue is when Excel tries to open the exported file the character appears before all £ signs, e.g. £232.00 when the value should be £232.00.
View 1 Replies
Jul 14, 2011
Question: How does the class for the serialization of this XML content look ?
<?xml version="1.0" encoding="utf-8"?>
<vcc:CreateTextSearchResponse xmlns:vcc="urn:veloconnect:catalog-1.1" xmlns:vct="urn:veloconnect:transaction-1.0">
[code]....
View 2 Replies
Oct 13, 2010
i am working on an application which calls the COM component of a partner's application.Ours is .Net, theirs isn't. I don't know much about COM; I know that the component we're calling is late-bound i.e.obj As Object = CreateObject("THIRDPARTY.ThirdPartyObject")We then call a method on this COM object (Option Strict Off in the head of the VB file):obj.AMethod(ByVal Arg1 As Integer, ByVal Arg2 As Integer, ByVal Arg3 as Boolean)I am a bit nonplussed that even though this call works, this overload doesn't exist in the COM interop .dll that is created if I instead add a reference to the COM server using Add Reference. The only available call to this method that it says is available is AMethod().
View 3 Replies
Mar 8, 2011
this one has me stumped - problem is bolded
Compiler Error Message: BC30456: 'Login1_Authenticate' is not a member of 'ASP.login_aspx'
<asp:LoginView ID="LoginView1" runat="server">
<LoggedInTemplate>
[code].....
View 6 Replies
Jan 15, 2010
ok I have a form.. has too much.. so I want to now use tab controlin VB6 I would delete then paste the object into the tab control andI recall it worked ok..with vs08 I cut and paste and looks ok.. but doesnt work..lets say I had button btnInstall when I paste it over its that name.. butwhen I click on it now.. it goes to btninstallButton_Click_1why did it put the _1 on there ? I didnt copy and paste .. I cut..
View 6 Replies
May 29, 2009
I got kind a mystery situation. There's not a lot of code, only few lines but the point is that it only works partially (it saves but does not load).
I tested it with another cmbbox1, which makes it work on seperate cmbboxes but not on either one or onother on their owns.[code..]
I got other cmbBoxes with titles on them loaded from the DB and they work fully, only this one doesn't.what should I look at?
View 15 Replies
Jun 28, 2011
I want to supress a key for a textbox: [code]this is working, B key is supressed,but adding just a messagebox will not work..[code]
View 1 Replies
Mar 14, 2012
I am trying to make a very simple aspx page that pulls some data from a mysql database.
The page builds without a problem. (the aspx contains just the default form and a div just to print some data)
[Code]....
View 1 Replies
May 23, 2011
I�m using Outlook to automatically send an email to my mobile phone. To bypass the stupid "security" bug in outlook I use redemption.safemailitem.Now, this has worked for years, but for some reason I can�t change the adress to which outlook sends the mail. Instead of sending to the adress in the code, it sends to an old adress that�s not anywhere in the code (but it was, ages ago)
View 6 Replies
Jun 24, 2008
It seems to be the general consensus from most places I have looked that the following code
Code:
Dns.GetHostEntry(Dns.GetHostName).AddressList()
Is the correct method of getting the local IP address of a machine, and when run against
[code]....
View 5 Replies
Apr 13, 2011
I cretaed a vb application where I concatenate a string to build XML code and Im getting an error stating that I must include a matching PURCHASE-ORDER-SHIP-TO end tag which clearly exists see below:
sMyXml = sMyXml + " <PURCHASE-ORDER-SHIP-TO>" sMyXml = sMyXml + " <DIRECT-QUESTIONS-TO>ATHOS PETROU</DIRECT-QUESTIONS-TO>" sMyXml = sMyXml + " <address:ADDRESS xmlns:address=""http://www.removed"">" sMyXml = sMyXml + " <address:NAME-LINE-1>Addr1</address:NAME-LINE-1>" sMyXml = sMyXml + " <address:NAME-LINE-2></address:NAME-LINE-2>"
[Code]...
View 3 Replies
