Re: Need help to find missing records in INFORMIX tables

joseph,leland w (leland@donner.cc.bellcore.com) wrote: : I have a problem with one of my INFORMIX tables. I cannot retrieve records : using PERFORM that I know exists in the table. When I submit an ACE program, : I can retrieve the records. Sorry, I don't have a solution, but I am experiencing a similar problem. Certain PERFORM masks let me query for data, and they display "XXX records found", but the data are not displayed! I can browse through the data with the "Forward" and "Backward" menu items, but no data are ever dis- played! This happens when I am querying as a user who is not owner of the table, but has DBA privileges on the database! When I su to the owner of the table, the PERFORM mask displays the data just fine. Anybody have any suggestions on how to overcome this? It is pretty annoying to have to su to the table owner every time I want to use the perform mask. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | Munich, Germany | | +----------------------------+-------------------------------------------+