Page 1 of 1

MySql, Firebird delete command

Posted: Mon 15 Apr 2013 14:40
by 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

Re: MySql, Firebird delete command

Posted: Wed 17 Apr 2013 07:13
by AndreyZ
Hello,

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

Code: Select all

delete from tablename