|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 3rd, 2006, 01:38 AM
|
|||
|
|||
|
SQL Tricking me.
Hello Folks, i have a problem, i am migrating my vb.net app from MS Access to Fb. I am getting a problem with this UPDATE Command. I am meant to Update the last User Record Entered in a table tblLoginDetails before i quit the database. but it gives me this error! and i dont know why.
Any Idea will be highly appreciated. Here is my Code Code:
Public Sub logOut()
Dim strSQL As String = "UPDATE tblLogTimes SET LoggedOut= " & Now & " WHERE(logID=" & getLastID() & ")"
Dim myConn As FbConnection = New FbConnection(strFBConn.ToString())
Dim cmdSQL As FbCommand = New FbCommand(strSQL, myConn)
MsgBox(strSQL)
Try
myConn.Open()
cmdSQL.ExecuteNonQuery()
Catch ex As OleDbException
MessageBox.Show("SQL Error:" & ex.Message)
Catch ex As Exception
MessageBox.Show("General Error:" & ex.Message)
Finally
myConn.Close()
cmdSQL.Dispose()
myConn.Dispose()
End Try
End Sub
Here is the error message in the attachment.
|
|
#3
July 3rd, 2006, 04:22 AM
|
||||
|
||||
|
Quote:
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#4
July 3rd, 2006, 04:31 AM
|
|||
|
|||
|
Quote:
Code:
Dim strSQL As String = "UPDATE tblLogTimes SET LoggedOut= '" & Now & "' WHERE(logID=" & getLastID() & ")"
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > SQL Tricking me. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
