Up Prev Next
From: "Sabherwal, Balvinder (MBS)"
<Balvinder dot Sabherwal at mortgagefamily dot com>
Subject: SQL failing
Date: Jul 14 2003 3:12PM
I have a script which connects to the Sybase database and create a work
table and has a check to see if the tables exists, drop it. The drop
statement is as below
$tblchk="if object_id(\"dbo.LatencyArch_staging\") is not null
drop table $opt_D\.\.$tbl
For some reason, the SQL gets executed and its not dropping the table. If I
print $tblchk from the debug mode and execute the generated sql from isql,
it works fine. What am I missing??