Re: ? Dynamic SQL ?

Gnana1 (gnana1@aol.com) wrote: : Try to form a text string (e.g sql_text = "CREATE TABLE ..." ) and run : EXECUTE IMMEDIATE sql_text : Hope this helps. : Thanx. : Ravi. EXECUTE IMMEDIATE doesn't work in 4GL. You should do the sequention: LET sql_comm = " CREATE TABLE ", mytable, " (", mycol1, ... PREPARE sql_stat FROM sql_comm EXECUTE sql_stat Cheers, -- Zdeno Miklas SOFTEC spol. s r. o. e-mail: ash@softec.sk Kutuzovova 23 phone : 42-7-273805 ext.128 831 03 Bratislava fax : 42-7-272537 SLOVAKIA