I encountered problem with merant drivers (odbc) for oracle 8i on solaris.scenario is as follows I have development,test,backup databases before moving to my production. Once my development freezes and i start moving tables to test(before that i shall move test db to backup db) I use Select * from ALL_TABLES where table_name='table i indent to move to test db' >if record exists then i execute "drop table ,create table queries" >If record doesn't exists then use "create table queries" The Problem i encounter is when i query the ALL_TABLES for table name i am getting record count as 0(but in real table exists) So my create table queries fail. I encounter this not often but 1 outof 10. Saro ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
