Hi thanks rebhan I did the same only, why I raised this question in email is to find out ..if there is any better approach then doing this....
Thanks skothari -----Original Message----- From: Rebhan, Gilbert [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 1:00 PM To: 'Ant Users List' Subject: RE: How to check whether database exists and then proceed ? -----Original Message----- From: Kothari, Shivani [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 9:19 AM To: Ant Users List; [EMAIL PROTECTED] Subject: RE: How to check whether database exists and then proceed ? /* Hi, Prob is I want to proceed further in the build script....in both the cases If db doesnot exists then prompt the user and continue the script and if does continue the script */ AFAIK, the sql task has no errorproperty like f.e. the java task,so you can't do stuff like that = <sql ... errorproperty="${sqlfailure} ..... > <target name="promptuser" if="sqlfailure"> ... but you may use the <sql onerror="fail"> within a <try> <catch> construct. try / catch is part of the antcontrib task suite, see = http://ant-contrib.sourceforge.net/tasks/tasks/trycatch.html download= http://sourceforge.net/project/showfiles.php?group_id=36177&package_id=2 8636 pick Version 1.0b2 or 1.0b3 Regards, Gilbert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
