I'm trying to connect to a database with a filename containing Chinese
characters.
The full path to my file is: C:\Users\汉密斯\AppData\Local\Rising
Software\data5cloud\rising5.fdb
I'm not able to connect to this filename - I'm always told that the path
name is wrong. I've tried using the full
Hi,
this is normal sql behavior
if you do not need to implicit INNER JOIN condition then move filter to left
join itself
in your situation:
instead “where mytable.id is not null” write “ AND mytable.id is not null”
...
select aux.n, mytable.id
from aux
LEFT JOIN mytable on aux.n between
Tuesday, October 3, 2017, 5:02:21 AM, Pierre wrote:
> I want to add readonly user creation/granting after database initialisation.
> I create the database using a bunch of SQL scripts. After the last
> script runs, I create a user using "create user MYUSER password
> 'myPassword'" the I grant
Hello Allan,
Tuesday, October 3, 2017, 1:02:48 AM, Allan Jardine wrote:
> In the mean time I've tried installing the Firebird package from
> dnf (I actually tried this first and have just tried it again). It
> appears to install okay, but then any interaction I try to make with
> the database I
Hello everyoneI'm having a problem, and I do not understand why.I have a
structure similar to:
with recursive
aux as (
select 0 as n
from rdb$database union all select aux.n + 1
from aux
where aux.n <= 20
)
select aux.n, mytable.id
from aux
LEFT JOIN mytable on aux.n
Hi,
I want to add readonly user creation/granting after database initialisation.
I create the database using a bunch of SQL scripts. After the last script
runs, I create a user using "create user MYUSER password 'myPassword'" the
I grant this user read only (select, references) access to every
Hi,
is there a way to backup and restore a database using the service manager?
The documentation gives example without service manager:
tux> gbak -backup emptest stdout | gbak -replace stdin emptest_2
But that needs to open the database in exclusive mode.
I've tried the following code but got
Le 01/10/2017 à 18:26, Allan Jardine allan.jard...@sprymedia.co.uk
[firebird-support] a écrit :
>
> I'm running into a problem installing Firebird on Fedora 26.
>
Please use the Fedora package
yum install firebird
and if really you need 3.0.2, under f26, ask for an update to Fedora
, or move