M MikeHorn New Member Nov 19, 2003 #1 Progress 9.1D06 Win2K Using SQL Explorer the following SQL92 statement keeps returning a syntax error. Why? IF EXISTS (SELECT tbl FROM sysprogress.systables WHERE "tbl" = 'DESPHIST2') DROP TABLE pub.DESPHIST2; Any and all advice gratefully received! TIA Mike
Progress 9.1D06 Win2K Using SQL Explorer the following SQL92 statement keeps returning a syntax error. Why? IF EXISTS (SELECT tbl FROM sysprogress.systables WHERE "tbl" = 'DESPHIST2') DROP TABLE pub.DESPHIST2; Any and all advice gratefully received! TIA Mike