Devart Forums

DB = Firebird 2.1.3

I have the following SQL code in TIBCQUERY
'UPDATE '+
Tablename+
' SET '+
'abt_abteilung = :abt_abteilung,abt_referenz = :abt_referenz '+
'where (id_abteilung = :id_abteilung);'

then come the Error

SQL Statement Doesn't return Rows

Can you Help me

Table Struck
ID_ABTEILUNG D_INT_ID NOT NULL /* D_INT_ID = BIGINT
ABT_ABTEILUNG "D_VCSTR-40" /* "D_VCSTR-40" =
ABT_REFERENZ INTEGER

You should use the Execute method instead of Open for UPDATE statements.