Take a look to charset used in text and the Charset of database... May be in
one record you use is an unsupported char... by the Charset of database... this
can happen if you paste a value... ( a value not build by your keyboard)
Le Dimanche 15 mars 2015 5h28, 'Chris LeFebvre' lefebv...@comcast.net
[firebird-support] firebird-support@yahoogroups.com a écrit :
I have at least a dozen different Firebird databases that I’ve created for
my own personal use over the years and I develop the front end in Delphi. I
recently created a new database for a project and I’d been adding new data into
it successfully until today when I tried to insert what would have been the
105th record and my program threw a SQL error -303. I tried a number of
different things to try and figure out what is causing the problem but when I
wasn’t making any headway I tried opening the database in Database Workbench
3.4.4 and querying the table that is having the problem and then manually
trying to add a new record and this is the error I’m getting: ISC ERROR
CODE:335544569 ISC ERROR MESSAGEDynamic SQL ErrorSQL error code =
-303Arithmetic exception, numeric overflow, or string truncationUnexpected end
of file on backup file The layout of the table is fairly simple: CREATE TABLE
PLAYLISTS(ARTIST CHAR( 100) COLLATE UTF8,TITLE CHAR( 100) COLLATE UTF8,GENRE
CHAR( 30) COLLATE UTF8,PORDER INTEGER,SONGNUM INTEGER,MAINKEY BIGINT,KEYFIELD
BIGINT NOT NULL,CONSTRAINT PK_PLAYLISTS PRIMARY KEY (KEYFIELD)) A little trial
and error turned up the fact that I can enter data in any column except the
Artist and Title, when I enter data into those fields and try and move to
another field I get the -303 error. This perplexes me since there are 104 other
records in the database that have been added successfully without any problem
and there is nothing strange or unusual about the text of the Artist and Title
that I’m attempting to insert; I even tried just making either field a single
character “a” and I get the same error. I’ve also discovered that I can’t edit
any of the other 104 records; for example if I attempt to edit a record with an
value of “Carlos Ortega” in the artist field and replace that with “a” and move
to another field I get the same -303 error. In case there was some damage to
the database I’ve even tried a backup and restore and I still have the same
problem on the restored database. I’ve tried using the Database Validation
Repair wizard and it simply says “No errors”. Does anyone have some insight
into this problem? Thanks,Chris LeFebvre #yiv2640494804 #yiv2640494804 --
#yiv2640494804ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv2640494804 #yiv2640494804ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804ads
{margin-bottom:10px;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad
{padding:0 0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad p
{margin:0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad a
{color:#ff;text-decoration:none;}#yiv2640494804 #yiv2640494804ygrp-sponsor
#yiv2640494804ygrp-lc {font-family:Arial;}#yiv2640494804
#yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc #yiv2640494804hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2640494804
#yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc .yiv2640494804ad
{margin-bottom:10px;padding:0 0;}#yiv2640494804 #yiv2640494804actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2640494804
#yiv2640494804activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2640494804
#yiv2640494804activity span {font-weight:700;}#yiv2640494804
#yiv2640494804activity span:first-child
{text-transform:uppercase;}#yiv2640494804 #yiv2640494804activity span a
{color:#5085b6;text-decoration:none;}#yiv2640494804 #yiv2640494804activity span
span {color:#ff7900;}#yiv2640494804 #yiv2640494804activity span
.yiv2640494804underline {text-decoration:underline;}#yiv2640494804
.yiv2640494804attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2640494804 .yiv2640494804attach div a
{text-decoration:none;}#yiv2640494804 .yiv2640494804attach img
{border:none;padding-right:5px;}#yiv2640494804 .yiv2640494804attach label
{display:block;margin-bottom:5px;}#yiv2640494804 .yiv2640494804attach label a
{text-decoration:none;}#yiv2640494804 blockquote {margin:0 0 0
4px;}#yiv2640494804 .yiv2640494804bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2640494804
.yiv2640494804bold a {text-decoration:none;}#yiv2640494804 dd.yiv2640494804last
p a {font-family:Verdana;font-weight:700;}#yiv2640494804 dd.yiv2640494804last p
span