DBISQL delete key button remove record from SYBASEIQ

[Former Member]

using interactive SQL version 9.0.1 for Sybase IQ 12.7 , on client machine when we select record from table and  after  hitting  the delete key all the record permanently deleted from database is there anyway by which can disable delete keyboard button .

[tayeb_hadjou · Accepted solution]

Hi Pandit,

To minimize this risk, I would suggest disable autocommit and "commit on exit/disconnect" options in intercative sql :

Menu/Tools/Options/Sybase IQ/Commmands

Or via DBA SQL commands :

Connect as DBA and set interactive sql options

set option public.Auto_Commit='off';

set option public.Commit_On_Exit='off';

set option DBA.Auto_Commit='off';

set option DBA.Commit_On_Exit='off';

In these conditions, If a delete is executed by mistake, then it can be rolled back with rollback command or if the connection is simply terminated.

Regards,

Tayeb.

[tayeb_hadjou]

It is possible in dbisql 12.0.x. I guess it is valid for dbisql 9.0.x too but I'm not sure.

Disable Edition option in Results Tab :

Menue/Tools/Options/Sybase IQ/Results/Disable Editing (check the option)

Menue/Tools/Options/Sql Anywhere/Results/Disable Editing (check the option)

Regards,

Tayeb.