Hi.
I would like to know if it is possible to display the plan of stored procedure
statements.
I'm interested in the plan of the statements inside the stored procedure (SP),
not the plan just informing that I'm executing an SP.
We are running also selectable SP's.
Att.
João
Hello,
Using FlameRobin, I can run this statement
GRANT rdb$admin TO USER MyUser;
However, I can't seem to run it in a script. I have a master script file that
runs a set of files. I tried it in a file, and directly
1) %SqlExe% -user '%Usr%' -password '%Pwd%' -input ..\Tables\aaaGrant.sql
Thank you both for your answers, both merges work!
Kyle
Of course Firebird didn't know.
And it seems to work.
Thank you
Have you tried
(cast(:PAar as integer) * 100) + cast(:PMDR as integer))
I've never tried it the exact setting as you're using, but I've had to use
cast when I've used a CTE to return a constant value (quite natural,
there's no simple and general way for Firebird to guess what type your
parameter
On 20-5-2016 13:21, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> I think you have too many `/` after the port number. Try
>
> sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.1.150:3050/c:\\Users\\elvis\\Documents\\VAS.fdb')
>
> It would also be very helpful to post the erro
On 17-5-2016 16:43, robert rottermann rob...@redcor.ch
[firebird-support] wrote:
> Hi there,
>
> I try to access a firebird db on windows from my ubuntu box.
> I have a gui-tool (FlameRobin), from which this works nicely. Therefore
> it is not a firewall or access problem.
>
> Now I would like to
Hi
I have installed Firebird 3.0. I'm testing our program up against this one.
Our databases are in SQL dialect 1.
I have a table like this:
CREATE TABLE MYTABLE
(
ID INTEGER NOT NULL,
NAME_ VARCHAR(30),
VALUEFLOAT NUMERIC(