Execute block indeed no worky. My sql looked like this:

set term ^ ;
execute block as begin
insert into ...;
insert into ...;
end ^

The .NET provider threw an FbException with the following error message:

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 5
term

Any ideas?

-matthew

On Fri, Jan 14, 2011 at 12:20 PM, Matthew Adams <matthew@...>wrote:

> I didn't use "set term ^ ;" though. I'll try again with that and let you
> all know.
>
>
> On Fri, Jan 14, 2011 at 12:19 PM, Matthew Adams <matthew@...>wrote:
>
>> I tried EXECUTE BLOCK. No worky.
>>
>>
>> On Fri, Jan 14, 2011 at 6:18 AM, Paul Vinkenoog <paul@...>wrote:
>>
>>>
>>>
>>> Daniel Rail wrote:
>>>
>>> > > No, you have to pass your statements one by one. This has nothing
>>> > > to with embedded vs. regular server, by the way.
>>> >
>>> > > Of course, some clients *do* support scripts. But they in turn pass
>>> > > the statements one after the other.
>>> >
>>> > Don't forget EXECUTE BLOCK, like Milan suggested.
>>>
>>> I must admit that I *did* forget that :-)
>>>
>>> Paul Vinkenoog
>>>
>>>
>>
>>
>>
>> --
>> mailto:matthew@...
>> skype:matthewadams12
>> yahoo:matthewadams
>> aol:matthewadams12
>> google-talk:matthewadams12@...<google-talk%3Amatthewadams12@...>
>> msn:matthew@... <msn%3Amatthew@...>
>> http://matthewadams.me
>> http://www.linkedin.com/in/matthewadams
>>
>>
>
>
> --
> mailto:matthew@...
> skype:matthewadams12
> yahoo:matthewadams
> aol:matthewadams12
> google-talk:matthewadams12@...<google-talk%3Amatthewadams12@...>
> msn:matthew@... <msn%3Amatthew@...>
> http://matthewadams.me
> http://www.linkedin.com/in/matthewadams
>
>


--
mailto:matthew@...
skype:matthewadams12
yahoo:matthewadams
aol:matthewadams12
google-talk:matthewadams12@...<google-talk%3Amatthewadams12@...>
msn:matthew@... <msn%3Amatthew@...>
http://matthewadams.me
http://www.linkedin.com/in/matthewadams


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