|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 28th, 2006, 04:42 AM
|
|||
|
|||
|
FirebirdSql.Data.Firebird.FbException ?
Hi, I am new to firebird database. I got "FirebirdSql.Data.Firebird.FbException" (arithmetic exception, numeric overflow, or string truncation
Implementation of text subtype 52 not located.) while trying to update my firebird database. My code for updation is :- Dim dbcon As IDbConnection = New FbConnection(connectionString) dbcon.Open() Dim dbcmd As IDbCommand= dbcon.CreateCommand dbcmd.CommandText = sSQL dbcmd.ExecuteNonQuery() my query looks like this:- "UPDATE HISTORY_MASTER SET Status='RUNNING', WHERE Mkey='5e81f9859d223ea420aca993c647b839' AND Status='Start';" Please help me in that. Thanks Nicky
|
|
#2
July 28th, 2006, 05:01 AM
|
||||
|
||||
|
Check the query alone from a client tool like Flamerobin
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE 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
|
|
#4
July 28th, 2006, 07:12 AM
|
||||
|
||||
|
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > FirebirdSql.Data.Firebird.FbException ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
