Re: Crystal 8.5 and informix database

You could set SQLIDEBUG in your env eq assuming windowze and c:\\tmp exist. set SQLIDEBUG=2:c\\tmp\\mydbg then use sqliprint (comes with csdk) to see what is in it eq the sql statements. maybe it can give you a hint why you are not seeing things do not forget to switch it of. Superboer. "Paulo Ferreira" <anonimo@clix.pt> wrote in message news:<42513f09$0$24490$a729d347@news.telepac.pt>... > Thanks, but once again this is not the case. > Please continue send more reasons. > Thanks. > > Paulo Ferreira > > "SaltTan" <SaltTan@gmail.com> escreveu na mensagem > news:c131837c.0504040105.14a29be5@posting.google.com... > > may be these tables have different owner? > > > > "Paulo Ferreira" <anonimo@clix.pt> wrote in message > > news:<424c2209$0$2211$a729d347@news.telepac.pt>... > >> Thanks, but this is not the case. > >> > >> > >> > >> "William Fields" <Bill_Fields@azb.uscourts.gov> escreveu na mensagem > >> news:d2h4ti$fu7$1@apollo.nyed.circ2.dcn... > >> > Could it be that the "tables" you're not seeing are actually > >> > parameterized > >> > views? > >> > > >> > We had the same issue when browsing Visual FoxPro databases, the issue > >> > turned out to be the views that were missing were parameterized. Can't > >> > remember off the top of my head if it was an OLE DB issue, or a CR > >> > issue. > >> > > >> > -- > >> > William Fields > >> > MCSD - Microsoft Visual FoxPro > >> > US Bankruptcy Court > >> > Phoenix, AZ > >> > > >> > "Beer is proof that God loves us > >> > and wants us to be happy." > >> > > >> > - Benjamin Franklin > >> > > >> > > >> > > >> > "Paulo Ferreira" <anonimo@clix.pt> wrote in message > >> > news:424bd608$0$2194$a729d347@news.telepac.pt... > >> >> Hello > >> >> > >> >> Can someone tell me why, when I try to open a database with a large > >> >> number > >> >> of tables, via odbc, more then 60% of the tables are not shown? > >> >> I'm using Crystal 8.5, Informix 7 and Win XP Pro. > >> >> Thanks. > >> >> > >> >> Paulo Ferreira > >> >> > >> > > >> >