MySql, Firebird delete command

[isysoftware]

Hi All,

I have developed an application (Delphi) over a MysQL Database.
Now, I'm changing MySql by Firebird.
I'm using the same components Unidac.

I have a problem with DELETE Sql statement:

In MySql: 'delete table.* from table'
In Firebird: 'delete from table'

So I need to change my source code for firebird.

There's a way to have a delete statement that works whit mysql and firebird without change my code?

Thanks

[AndreyZ]

Hello,

You can use the following statement for both MySQL and Firebird:

Code: Select all

delete from tablename