is/will there support to be able to write adhoc sql scripts like in MSSQL
Server?

I would really like to see this functionality, because in MSSQL sever
(which is what i used to work with before i left my last job) I found that
the ability to be able to write scripts with variable support along with
while, If..then, case, etc statements were one of the most useful aspects
of MSSQL. I was hoping that this would be the case with firebird.

Regards
Martin.

At 02:33 PM 8/06/03 +1000, you wrote:

>At 02:18 PM 8/06/2003 +1000, you wrote:
> >Im trying to write some sql script (not inside a procedure or trigger) to
> >modify some data in my tables using variables to temporarily store data and
> >use it a little further on in the script. This is an example of what i have
> >at the moment:
> >
> >declare variable MaxValue integer;
> >
> >which from what i have read of the documentation is correct syntax
>
>-- but not in scripts! You can declare variables in stored procedures and
>triggers, but not in scripts, which are just batches of SQL statements.
>
>And you can't use stored procedures to perform DML.
>
> > but when
> >i run it I get the following error:
> >
> >Dynamic SQL Error
> >SQL error code = -104
> >Token unknown - line 1, char 9
> >variable
> >Statement: declare variable MaxValue int
>
>Yup. It's just the parser telling you it doesn't know about a DSQL keyword
>"VARIABLE".
>
>heLen
>
>
>
>
>Yahoo! Groups Sponsor
>
><http://rd.yahoo.com/M=247865.3355058.4641699.1261774/D=egroupweb/S=1705115386:HM/A=1482387/R=0/SIG=16nlra259/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1055046982%3eM=247865.3355058.4641699.1261774/D=egroupweb/S=1705115386:HM/A=1482387/R=1=1055046982%3eM=247865.3355058.4641699.1261774/D=egroupweb/S=1705115386:HM/A=1482387/R=2>c1e474.jpg
>c1e4f7.jpg
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/03

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/03


[Non-text portions of this message have been removed]