when using EXECUTE STATEMENT on an external database.
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
>
> *From:* Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]
> *Sent:* Monday, January 6, 2020 4:52 PM
> *To:* firebird
020 14:48, Eric Guéguiniat eric.gueguin...@gmail.com
> [firebird-support] wrote:
> > I can't use Stored procedure to do this, because index are not used with
> it
>
> Index cannot be used with ES either, so there is no difference and no need
> in a view.
>
> --
> WBR, SD.
>
>
Hello,
Is it possible to create a view on external table ?
I need to replace a table of the DB by an external table. Like this I don't
need to modify my stored procedures
I can't use Stored procedure to do this, because index are not used with it
I tried to do this, but it's not correct :
Hi,
I made a demo just to connect an fb embedded DB
Compile it and run it where you have intalled firebird files (change file
path)
If you can't connect DB with this, I will give you the exe file
And if it works only with my exe,, then the problem comes from DXE10.3.1
Eric
[Non-text portions
I compiled my program in WIN64 and connected DB
..\examples\empbuild\EMPLOYEE.FDB with FB3 embedded x64, but I used Delphi
XE10.2.3 ...
To have the exactly your error “[FireDAC]{Phys][FB]unavailable database” I
must set : FDConnection.Params.Database := '';
Have you sure that property
Hello,
I have a issue with blob in a stored procedure with BLOB variable.
Blob variable is returned by a suspend in a "while do", but the memory
allocated to the blob is not released, so memory takes by fbserver increase
until a out of memory failure (up to 2Go, the max size of a 32bit
Thank you
Second option is what I did finally and it works perfect
Thank you Dimitry !
Now it works as I wanted ;)
By example how to do that :
SELECT IDSYSCONFGROUP FROM SYS_CONF_GROUP
WHERE UPPER(CAST(SYSGROUP_NAME AS VARCHAR(100) CHARACTER SET ISO8859_1)
COLLATE FR_FR_CI_AI) = 'CAMERA'
SYSGROUP_NAME can be written like this : caméra, camera,camèra,camêra ..
Other case, I load all country's
Thank you Dimitry,
In fact I wanted the result of FB25 (without accents)
It is possible to remove accents by using charset with FB3 in the select
clause ?
Thank you
Eric
Hello,
My Database CHARSET is WIN1252
Ex : SELECT UPPER(CAST('caméra' AS VARCHAR(100) CHARACTER SET ISO8859_1)
COLLATE FR_FR)from RDB$DATABASE
FB25 => CAMERA
FB3 => CAMÉRA
Could you explain why the result of this query is not the same with FB3 and
FB25 ?
I used this query to
Hello,
My Database CHARSET is WIN1252
Ex : SELECT UPPER(CAST('caméra' AS VARCHAR(100) CHARACTER SET ISO8859_1)
COLLATE FR_FR)from RDB$DATABASE
FB25 => CAMERA
FB3 => CAMÉRA
Could you explain why the result of this query is not the same with FB3 and
FB25 ?
I used this query to
I solved my problem, in fact it was a bug in Devart DBExpress driver
You can closed this topic
Thanks
Hello,
My program can't reconnect to server FB when network was lost.
I made some tests and it happends only when I use fbclient.dll FB3
My program is write in Delphi XE5 and I use DBExpres Devart to connect the
database.
My setting :
WIN10
Delphi XE5
FIrebird server 3.03
Devart
Hello,
My program can't reconnect to server FB when network was lost.
I made some tests and it happends only when I use fbclient.dll FB3
My program is write in Delphi XE5 and I use DBExpres Devart to connect the
database.
My settings :
WIN10
Delphi XE5
FIrebird server
Hi Vlad,
In firebird.log the message is :
SRV-BM Thu Apr 05 14:30:51 2018
Operating system call MapViewOfFile failed. Error code 8
SRV-BM Thu Apr 05 14:30:51 2018
LockManager::LockManager()
operating system directive MapViewOfFile failed
Espace insuffisant pour traiter cette
Hi Vlad,
In firebird.log the message is :
SRV-BM Thu Apr 05 14:30:51 2018
Operating system call MapViewOfFile failed. Error code 8
SRV-BM Thu Apr 05 14:30:51 2018
LockManager::LockManager()
operating system directive MapViewOfFile failed
Espace insuffisant pour traiter cette
FB3.02 on Microsoft Windows Server 2008 R2
I had error MapViewOfFile failed many times on Microsoft Windows Server 2008
When this error occurs it's impossible to connect database, but I can connect
to an other database
My database seems reject all connexions
The only way to
Hi Mark,
Sorry for the late reply
I did what you said, but impossible to recover the record.
The record is not visible even with a full scan and after have drop the index
I used the tool IBSurgeon and nothing, the record seems definitively lost.
My database is on Force Write Off,
Hi,
I have the database before backup/restore
I have an error with gfix on validating
Summary of validation errors
Number of index page errors : 3
Number of database page warnings : 1
IBE: Validation completed.
So, after backup/restore the record is still lost, but now I
Thank you,
I'am sure that no client has deleted the record, because a trigger logs all
deleting in table in my database
Backup/restore done and with no succes
I can't check HD, but an error only on one record could be possible ??
At this time, the database works with no problem
Hello,
We have a strange thing on a firebird 3.0.2 database
One only Machine on Windows (Microsoft Windows Embedded Standard)
We lost a record in a database
Circumstances :
Power off of the computer in activity
After restart our program doesn't work ( Qt
Hello,
I want to post bug reports on your group.
When I can do it ?
Thanks
Eric Guéguiniat
23 matches
Mail list logo