OK, I guess there is not available better solution than quite risky:
in autonomous transaction do execute statement 'alter table accounts add
balance double precision';
etc.
Hi!
I am using Firebird 3 and I need to write one execute block statement which
makes several alter table and update table commands, like:
execute statement 'alter table accounts add balance double precision'
execute statement 'update accounts set balance=previous_balance+10'
etc.
The problem
This should explain:
https://www.youtube.com/watch?v=yepjPiVIzPc
--
pozdr,
Michał Kurczabiński
29.03.2017 0:27, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]
wrote:
> I have wasted a lot of time but succes yet to come.
void foo()
#ifdef __WIN32__
__declspec(dllexport);
#else
__attribute__((visibility ("default")));
#endif // __WIN32__
--
WBR, SD.
Hello Dmitry,
>28.03.2017 10:06, Martijn Tonies wrote:
>>
>> So the first 'fetch' operation on a position that's invalid returns
>> "rowcount=0",
>> any additional fetch (which includes a move) returns an exception?
>
>Yes. Moving cursor from "last" to EOF is perfectly valid, "no data"
28.03.2017 10:06, Martijn Tonies wrote:
>
> So the first 'fetch' operation on a position that's invalid returns
> "rowcount=0",
> any additional fetch (which includes a move) returns an exception?
Yes. Moving cursor from "last" to EOF is perfectly valid, "no data"
condition is not an error (as