|
Hello,
I would like to ask why do I get a run time error that says
"invalid insert into command" while updating a database records. But if the database records field is less than 8 it works well.
The database I am using is ms access/.mdb and the connection I use is oledb connection.
Any comments or suggestion are kindly appreciated.
Thanks,
dfan23
|
|
|
|
|
That error indicates you are trying to insert some invalid data into your database. Without knowing how you db is laid out and what you are trying to insert, there's no way to know what went wrong.
Common problems include trying to save data that isn't consistent with the db field definition, trying to duplicate a primary key value, trying to save into a field that doesn't exist, etc.CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Hello,
Sir this my database
FIELD Name | Data Type
ID number
lastName text
firstName text
middleName text
contactNum number
add text
eAdd text
status text
position text
This is my save code command
Try
con.Open()
Dim dt As New DataTable
Dim ds As New DataSet
ds = New DataSet("DataSet")
ds.Tables.Add(dt)
Dim da As OleDbDataAdapter
da = New OleDbDataAdapter("Select * from empTable", con)
da.Fill(dt)
con.Close()
Dim newrow As DataRow = dt.NewRow
With newrow
.Item("ID") = Val(txtEmpIDAdd.Text)
.Item("lastName") = txtLastAdd.Text
.Item("firstName") = txtFirstAdd.Text
.Item("middleName") = txtMiddleAdd.Text
.Item("contactNumber") = Val(txtContactAdd.Text)
.Item("add") = txtAddressAdd.Text
.Item("eAdd") = txtEmailAdd.Text
.Item("status") = cmbStatusAdd.Text
.Item("position") = txtPositionAdd.Text
End With
dt.Rows.Add(newrow)
con.Open()
da = New OleDbDataAdapter("Select * from empTable", con)
Dim cb As New OleDbCommandBuilder
cb = New OleDb.OleDbCommandBuilder(da)
da.Update(dt)
con.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
This save code does not work if my database field is 9 above,
but when I delete some fields the code work.
Thanks for immediate response.
Thanks,
dfan23
|
|
|
|
|
Hello,
I got the solution now sir.
I have noticed that word "position" is a reserved word in
database
thanks,
dfan23
|
|
|
|
|
Great! Glad to hear you found the problem.
I've run into problems with reserved words, too. It can be very frustrating!CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Your 8th field appears to have an issue when inserting into the database.
Post some code here and someone will be able to help.Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|
Hello,
Sir this my database
FIELD Name | Data Type
ID number
lastName text
firstName text
middleName text
contactNum number
add text
eAdd text
status text
position text
This is my save code command
Try
con.Open()
Dim dt As New DataTable
Dim ds As New DataSet
ds = New DataSet("DataSet")
ds.Tables.Add(dt)
Dim da As OleDbDataAdapter
da = New OleDbDataAdapter("Select * from empTable", con)
da.Fill(dt)
con.Close()
Dim newrow As DataRow = dt.NewRow
With newrow
.Item("ID") = Val(txtEmpIDAdd.Text)
.Item("lastName") = txtLastAdd.Text
.Item("firstName") = txtFirstAdd.Text
.Item("middleName") = txtMiddleAdd.Text
.Item("contactNumber") = Val(txtContactAdd.Text)
.Item("add") = txtAddressAdd.Text
.Item("eAdd") = txtEmailAdd.Text
.Item("status") = cmbStatusAdd.Text
.Item("position") = txtPositionAdd.Text
End With
dt.Rows.Add(newrow)
con.Open()
da = New OleDbDataAdapter("Select * from empTable", con)
Dim cb As New OleDbCommandBuilder
cb = New OleDb.OleDbCommandBuilder(da)
da.Update(dt)
con.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
This save code does not work if my database field is 9 above,
but when I delete some fields the code work.
Thanks for immediate response.
Thanks,
dfan23
|
|
|
|
|
Hi,
rather than providing some information twice, you'd better tell us which database you are using, and what the exact error/exception information is you are getting for one or two specificied situations ("when I delete some fields the code work" is too vague). Your app is showing Exception.ToString() which is very good, but you failed to reproduce it here.
 Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hello,
Sir the database I am using is ms Access database
Thanks,
dfan23
|
|
|
|
|
Hello,
I got the solution now sir.
I have noticed that word "position" is a reserved word in
database.
thanks,
dfan23
|
|
|
|
|
Hi All,
This is my first post and hope i am placing it in the right forums -
I have the following class
Class User
Dim UserID as integer
Dim IsActive as boolean
Dim Username as string
End Class
i need to perform lookups on UserID or IsActive
Get user with ID = X (returns one object)
Get all active Users (returns multiple objects - possibly a list)
Get all inactive users (returns multiple objcets - possibly a list)
for quicker retrieval using userid, i intend to use the generics dictionary
dim Users as Dictionary (Of integer, User)
are there any generics implementations which allow me to use quickly retrieve all active users or inactive users as well?
Just wanted to check with you experts before embarking on my own.
Thanks in advance
Kalyan
|
|
|
|
|
you could:
- just use a dictionary (key=UserId) and test IsActive as appropriate;
- keep one dictionary (key=UserId), and two lists (one with active, one with inactive users);
- keep two dictionaries, one with active and one with inactive users;
- use a DataTable;
- use lambda expressions.
IMO the best choice depends a bit on the circumstances where you need it.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hi Luc,
Thanks for a quick reply.
I looked at generics and was hoping there may be a complex alternative which i might find interesting 
i have opted for the following to keep it simple
1 dictionary for quick retrieval by userid
2 lists for containing active and inactive users.
i wonder how this will scale for larger number of users!
Thanks to you i learnt about lambda expressions today. 
Go you still prefer datatables for these kind of operations when dealing with disconnected data?
Cheers
Kalyan
|
|
|
|
|
you're welcome.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
HI to all.
I have a simple question. I'm trying to create a bitmap from a memory stream. The memory stream is filled with a byte array and there isn't image information, only raw pixel data.
Now I'm confusing because the C# sample code I found in internet runs without errors
<br />
private Image GetImage (long position, int size)<br />
{<br />
string string1;<br />
byte[] byteArray1;<br />
Bitmap bitmap1;<br />
Stream stream1 = ((Stream) null);<br />
BinaryReader binaryReader1 = ((BinaryReader) null);<br />
MemoryStream memoryStream1 = ((MemoryStream) null);<br />
try<br />
{<br />
string1 = string.Format ("{0}gallery{1:D2}.enc", Session.RootPath, this.index);<br />
stream1 = ((Stream) File.OpenRead (string1));<br />
binaryReader1 = new BinaryReader (stream1, Encoding.ASCII);<br />
long int64_1 = binaryReader1.BaseStream.Seek (position, SeekOrigin.Begin);<br />
byteArray1 = binaryReader1.ReadBytes (size);<br />
this.ColorBalance (byteArray1);<br />
memoryStream1 = new MemoryStream (byteArray1);<br />
try<br />
{<br />
bitmap1 = new Bitmap (((Stream) memoryStream1));<br />
}<br />
catch<br />
{<br />
bitmap1 = new Bitmap (64, 64);<br />
}<br />
}<br />
finally<br />
{<br />
if (memoryStream1 != null)<br />
{<br />
memoryStream1.Close ();<br />
memoryStream1 = ((MemoryStream) null);<br />
}<br />
if (binaryReader1 != null)<br />
{<br />
binaryReader1.Close ();<br />
binaryReader1 = ((BinaryReader) null);<br />
}<br />
if (stream1 != null)<br />
{<br />
stream1.Close ();<br />
stream1 = ((Stream) null);<br />
}<br />
}<br />
return bitmap1;<br />
}<br />
while the conversion to VB.Net (2008) written by me raise an exception
<br />
Private Function _getImage(ByVal _position As Long, ByVal _size As Integer)<br />
Dim _bmp As New Bitmap(64, 64)<br />
Try<br />
Dim _stream As Stream = File.OpenRead(_file)<br />
Dim _binaryReader As BinaryReader = New BinaryReader(_stream, Encoding.ASCII)<br />
<br />
Dim _int64 As Long = _binaryReader.BaseStream.Seek(_position, SeekOrigin.Begin)<br />
Dim _byteArray As Byte() = _binaryReader.ReadBytes(_size)<br />
<br />
_colorBalance(_byteArray)<br />
Dim _memoryStream As New MemoryStream(_byteArray)<br />
_bmp = Bitmap.FromStream(_memoryStream) '<--- "Invalid data" exception<br />
<br />
_memoryStream.Close()<br />
_binaryReader.Close()<br />
_stream.Close()<br />
Catch ex As Exception<br />
MessageBox.Show(ex.Message, "Get Image error", MessageBoxButtons.OK, MessageBoxIcon.Error)<br />
End Try<br />
Return _bmp<br />
End Function<br />
Why the C# code runs and the VB not? Where I'm wrong?
Thanks.
Perry
P.S.: sorry my english, if you can... 
|
|
|
|
|
Instead of :
xry2006 wrote: _bmp = Bitmap.FromStream(_memoryStream)
I recommend :
_bmp = New Bitmap(_memoryStream)
A subtle difference I know, howeer the difference is more than just returning a bitmap rather than an image.
Bitmap.FromStream ends up calling GdipLoadImageFromStream in the GDIPlus.dll
New Bitmap(stream) calls GdipCreateBitmapFromStream in the GDIPlus.dll
I assume the Bitmap version includes more handling for different image types.
|
|
|
|
|
Hi. Thanks for the reply. I'd try your suggestion but the exception "Invalid parameter" remain.
|
|
|
|
|
Could you try it out. Could be something you missed in translation, though I couldn't spot it.
Private Function GetImage(position As Long, size As Integer) As Image
Dim string1 As String
Dim byteArray1 As Byte()
Dim bitmap1 As Bitmap
Dim stream1 As Stream = DirectCast(Nothing, Stream)
Dim binaryReader1 As BinaryReader = DirectCast(Nothing, BinaryReader)
Dim memoryStream1 As MemoryStream = DirectCast(Nothing, MemoryStream)
Try
string1 = String.Format("{0}gallery{1:D2}.enc", Session.RootPath, Me.index)
stream1 = DirectCast(File.OpenRead(string1), Stream)
binaryReader1 = New BinaryReader(stream1, Encoding.ASCII)
Dim int64_1 As Long = binaryReader1.BaseStream.Seek(position, SeekOrigin.Begin)
byteArray1 = binaryReader1.ReadBytes(size)
Me.ColorBalance(byteArray1)
memoryStream1 = New MemoryStream(byteArray1)
Try
bitmap1 = New Bitmap(DirectCast(memoryStream1, Stream))
Catch
bitmap1 = New Bitmap(64, 64)
End Try
Finally
If memoryStream1 IsNot Nothing Then
memoryStream1.Close()
memoryStream1 = DirectCast(Nothing, MemoryStream)
End If
If binaryReader1 IsNot Nothing Then
binaryReader1.Close()
binaryReader1 = DirectCast(Nothing, BinaryReader)
End If
If stream1 IsNot Nothing Then
stream1.Close()
stream1 = DirectCast(Nothing, Stream)
End If
End Try
Return bitmap1
End Function
|
|
|
|
|
Hello Everyone
I am having a hard time here can anyone help me please
I am trying to have my timer reset i have it couting up at 1 second interval when i stop it and start it agine
it keeps counting from ware it left off , i want it to reset to 0
Thanks
Bob
Public Sub OnOff_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OnOff_Button.Click
If Form1.phidgetIFK.outputs(2) = False Then
Form1.phidgetIFK.outputs(2) = True
TextBox1.Text = "0"
Timer1.Enabled = True
Timer1.Interval = 1000
Else
Form1.phidgetIFK.outputs(2) = False
Timer1.Enabled = False
End If
End Sub
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Toolclick += 1
TextBox1.Text = Toolclick.ToString
End Sub
|
|
|
|
|
Bob Beaubien wrote: TextBox1.Text = Toolclick.ToString
 Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hay Luc
Do you have a other Clue i still can figer it out ?
|
|
|
|
|
i got it luc i used this insted
TextBox1.Text = Val(TextBox1.Text) + 1
Thanks
Bob
|
|
|
|
|
either that or, better, reset the variable you were using when you need to.
Now name two reasons why the latter is better!
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hi all,
I have a little problem with a pair of arrays, when them are involved in a comparation work:
In particular, I have an Array A As String and another array B As String.
Normally the program works with a single array A, but sometimes I need a second array B.
Array A is filled with numerical string (sometime with up 15000 elements).
Array B is filled with numerical string (sometime with up 15000 elements).
The code works in this way:
Each element of array B is compared with Each element of array A.
If a value of array B is = to some value in array A then the value in the array B is removed and the array is resized (progressively size-decreased) but preserving remaining different values (Redim Preserve).
In this way, at the end of comparation loop, the array B will contain only values that are not already contained in array A.
The code seems to be perfectly working until the number of elements in array A and B is down about 2200 + 2200 elements, but if numbers of arrays element go up, the program seems to work (in an infinite loop) but in reality it is quited (closed) from O.S.
In the fact the program name disappears from list of running program.
The following is the schematic code:
Do Until IndexB = ArrayB.GetLength(0)
For IndexA = 1 to ArrayA.GetLength(0)
If Val(ArrayB(IndexB)) = Val(ArrayA(IndexA)) Then
ArrayB(IndexB) = ArrayB(ArrayB.GetLength(0) - 1)
ReDim Preserve ArrayB((ArrayB.GetLength(0) - 1) - 1)
IndexB = IndexB - 1
Exit For
End If
Next
IndexB = IndexB + 1
Loop
Application is running in a Windows Mobile 6.1 Device.
Apparentely seems to be a memory problem, but I don't think so, because size of arrays is not exagerate and the device have enough available memory.
Thanks for help.
|
|
|
|
|
Hi,
this is horribly inefficient for many reasons:
- you are converting strings to numbers all the time; it they really are numbers, store them in a numeric data type, not string.
- ReDim Preserve is expensive as it has to allocate a new array, then copy all the data. When the number of items in a collection varies, you should consider using a real collection instead of an array; use a collection type if those are available, or create your own linked list structures.
- For two arrays of size S1 and S2, you are performing S1*S2 comparisons. It would be cheaper to sort the first array, sort the second array, and then perform the equivalent of a merge-sort on both. This will improve speed dramatically and reduce the memory load drastically.
So throw it all out; start using lists of numbers; then sort and merge. It would handle millions of numbers in a matter of seconds.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
modified on Friday, February 26, 2010 1:50 PM
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
