"Jiri Cincura" <diskuze-i04QUkT9ABbR7s880joybQ@xxxxxxxxxxxxxxxx> wrote in
message
news:45D4DE2F.6070709-i04QUkT9ABbtq/LXCagqSw@xxxxxxxxxxxxxxxx
> Atli Oddsson wrote:
>> The function doesn't have any case for the RECREATE statement although
>> this
>> syntax is provided by Firebird.
>
> Thanks, we will fix it.
Fantastic!
>
>> Hasn't anyone encountered this? I think it's really convenient instead
>> of
>> using CREATE/ALTER because it means I can keep all my procs in the same
>> place when it comes time to upgrade the database.
>
> Just small OT, with recreate you can find problems with depedencies. :)
yeah, I can see what you mean... I'm going to have a special script file for
data manip and create table etc and another for SP and views. I guess I'll
just have "drop proc" in the script file to get around any dependency issues
that might occur.
Thanks!
Atli
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
|
