SQL STatement Doesn't return Rows

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ede
Posts: 1
Joined: Sat 23 May 2009 13:38

SQL STatement Doesn't return Rows

Post by ede » Thu 14 Jan 2010 12:13

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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 15 Jan 2010 12:10

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

Post Reply