Re: problem with select/isql/dbaccess?

You could try checking the indexes on that table. Don't know if that will help, but I suppose it can't hurt. rakesh parmar <parmar_rs@usa.net> on 30/06/2000 07:46:04 To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) Subject: 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