Makes me wish I had better luck trying to get 1.5 to compile under
Solaris.

R.

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, June 03, 2003 1:13 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] ALTER INDEX in a Stored Procedure


Hi Robert,

> I can't seem to ALTER INDEX or SET STATISTICS in a stored procedure.

Am

> I missing anything? Thanks!

Both are DDL commands. Not possible in a stored procedure.

Unless - if you're using Fb 1.5, you can use:

EXECUTE STATEMENT 'ALTER INDEX name ... ';


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.