Le 25/07/2012 11:05, Dimitry Sibiryakov a écrit :
> 25.07.2012 10:59, arnaud but wrote:
>> i know but the problem is in an INSERT statement (on thi table) after
>> the prepare the sqltype of this comlums is 448 (base10) so sqltype & 1
>> == 0 maybe it's normal.
>
> It is NOT normal. And I suspect, that this is result of YOUR database
> corruption.
> Show us table description and SQLDA dump from isql to avoid possible Qt
> problems.
>
Sorry Dimitry the difference is in Qt in fact before it don't include
the primary key in the insert and now it do it.
but effectively if it's not normarl to have sqltype & 1 == 0 on a
primary key column (in fact i have this result since the beginning with
the Qt driver) this is strange
Table Sys_conf_prmval :
IDSYSCONFPRMVAL (IDENT) VARCHAR(22) Not Null
REFPARAM (REFERENCE) VARCHAR(22) Not Null DEFAULT
'-1'
REFNODE (REFERENCE) VARCHAR(22) Not Null DEFAULT
'-1'
REFID (REFERENCE) VARCHAR(22) Not Null DEFAULT
'-1'
FOREIGNID (REFERENCE) VARCHAR(22) Nullable DEFAULT
'-1'
PRMVAL_VALUE (LIB250) VARCHAR(250) Nullable DEFAULT ''
CREATESITE (REFERENCESITE) VARCHAR(22) Nullable
CREATEDATE (DATECOMPLETE2) TIMESTAMP Not Null
DEFAULT 'now'
FTPDATE (DATECOMPLETE2) TIMESTAMP Not Null
DEFAULT 'now'
REFSITE (REFERENCESITE) VARCHAR(22) Nullable
CONSTRAINT PK_SYS_CONF_PRMVAL:
Primary key (IDSYSCONFPRMVAL)
Triggers on Table SYS_CONF_PRMVAL:
SYS_CONF_PRMVAL_BI, Sequence: 0, Type: BEFORE INSERT, Active
SYS_CONF_PRMVAL_BU, Sequence: 0, Type: BEFORE UPDATE, Active
SYS_CONF_PRMVAL_SUP, Sequence: 0, Type: AFTER DELETE, Active
----------------------------------------------
SQLDA DUMP :
prepare: INSERT INTO SYS_CONF_PRMVAL ("IDSYSCONFPRMVAL", "REFPARAM",
"REFNODE", "REFID", "FOREIGNID", "PRMVAL_VALUE", "REFSITE") VALUES (?,
?, ?, ?, ?, ?, ?)
DUMP :
sqld : 7
sqldabc -842150451
sqlaid : ÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
sqln : 7
sqlversion : 1
XSQLVAR : (for the primary key)
sqltype : 448
scale : 0
sqlsubtype : 0
sqllen : 22
sqlind : 0x0
---------------------------------------------------------------------------------------------
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
