Re: [Re: problem with select/isql/dbaccess?]

HI Sue, Yes, We have got a unique index on tran_num and tran_date. But, I find that there are duplicate records in the table. I do not understand why & how it happens although we have got a unique index on it. Thanks for your reply & please suggest me what to do? Rakesh. Sue_Davidson@exe.com.au wrote: 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 ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1