problem with select/isql/dbaccess?

HI All, I have got a strange problem with dbaccess/isql. Through a 4GL code, I am inserting three records in a table. There is no trigger or cascade delete on this table. A 4GL code runs properly without any error message. With dbaccess/isql, when i select records from this table, it gives me a single row like. select * from tab1 where tran_num = 6 (1 rows selected) But, When I tried to delete the same row like. delete from tab1 where tran_num = 6 (3 rows deleted) I will appreciate any comments/solutions for it. Thanks in advance, Rakesh. ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1