By the way, google's query language has a PIVOT syntax:
https://developers.google.com/chart/interactive/docs/querylanguage#Pivot
Eg.
select sum(salary) pivot dept
Would be nice if Firebird could do the same, I understand you couldn't use it
inside a stored procedure, where your columns need
By the way, google's query language has a PIVOT syntax:
https://developers.google.com/chart/interactive/docs/querylanguage#Pivot
Eg.
select sum(salary) pivot dept
Would be nice if Firebird could do the same, I understand you couldn't use it
inside a
stored procedure, where your columns need
I have:
ldd /usr/sbin/fbserver | grep icu
libicuuc.so.52 = /usr/lib/i386-linux-gnu/libicuuc.so.52 (0xb75a3000)
libicudata.so.52 = /usr/lib/i386-linux-gnu/libicudata.so.52 (0xb5c1a000)
This is more update and worked for me in Ubutun 14.04 beta 32bits:
ldd /usr/sbin/fbserver | grep icu
libicuuc.so.52 = /usr/lib/i386-linux-gnu/libicuuc.so.52 (0xb75a3000)
libicudata.so.52 = /usr/lib/i386-linux-gnu/libicudata.so.52 (0xb5c1a000)
Hi
I want to fix my software usage of SYSDBA/masterkey and would appreciate
pointers to fastest/best way to do so. I have +- 100 installations running on
WinXp/Win7 and Firebird 2.5.1 or 2.5.2. The software is develop with Delphi
XE2/DBX. For a start I just want to copy the rights of
What about creating a user with the RDB$ADMIN role?
Greetings.
Walter.
On Wed, Jan 8, 2014 at 8:41 AM, corni...@gmail.com wrote:
Hi
I want to fix my software usage of SYSDBA/masterkey and would appreciate
pointers to fastest/best way to do so. I have +- 100 installations running
on
Which ICU version need the Firebird version 2.5.2 update 1?
In my OS i also have installed the ICU48. But firebird 252 update 1 does not
seem to use it. How i can solve this? Which version of icu to install for
firebird and how to make firebird using it? Thank you
it is a ubuntu 14.04 packaged error:
https://bugs.launchpad.net/ubuntu/+source/firebird2.5/+bug/1267128
dear rudyhuan...@ymail.com
I think this link will help you: http://www.destructor.de/firebird/gsec.htm
On Wed, Jan 8, 2014 at 2:21 PM, liviusliv...@poczta.onet.pl
liviusliv...@poczta.onet.pl wrote:
Hi,
Your design is wrong from security POV
If you need to protect db from copy - put it
Dear All,
Thank you for your response.
Maybe i will protect my database by adding some role.
That makes it difficult to access my database.
Thank you Thomas Steinmaurer (UPSCENE) for your suggestion.
Regards Thanks,
Rudy Huang
I looked through previous topics, and although this seems like a common error,
I didn't find one quite like my situation. I'm using a TIBCQuery in Delphi
2007. SQL.Text := 'Select * From AR ORDER BY DueDate, TransDate, PolNum;'; The
error occurs when I issue an Insert, or Close command. Actual
I thought I had it fixed by switching to a different TIBCQuery to insert a new
record. That worked fine. However, the same problem exists when I try to alter
the SQL in order to filter the result set in the grid.
The exact same error (exactly the same) happens when I close the query to
alter
Try 'Append' instead of 'Insert'
Hi,
I'm running Firebird 2.5.2 SuperServer on a Windows 7 Professional 64-bit PC.
The PC currently has 4 GB of RAM, but we plan to upgrade to 8 GB soon.
The database is a small database used for inventory and stock control with
about 30 tables, with about 6 - 8 concurrent users, and relatively
Thanks, Steve, but that was one of the first things I tried. Didn't work. I
solved the insert problem by using a different TIBCQuery component, however now
I can't close the query without producing the same error. Please see the code
in my prior post.
At 10:37 a.m. 9/01/2014, ho...@agencybusys.com wrote:
I looked through previous topics, and although this seems like a common error,
I didn't find one quite like my situation.
You realise this is a problem with your Delphi client code, don't you? And
that this list is not a Delphi support
Hello,
We are currently having trouble entering data on one of our tables. We are
trying to enter data on specific columns, but after refreshing it, the data is
lost. Here is the outline of our table:
CREATE TABLE PAYMENT
(
PAYMENT_DATE Timestamp DEFAULT current_timestamp NOT
Hi Steve,
This database is very small, you should not have any performance
problems (except related with lack of indices or bad design of metadata).
Usually we recommend to set 1 buffers for SuperServer - our
experiments have shown that 1 is the best # of buffers for SuperServer.
Hi all, is it possible to transfer the content of a table to a new one?
Thanks,
Thanks for the advise. I sincerely appreciate it. In my defense, this Delphi
application has just shy of 900,000 lines of my code. The Data Module alone has
115 TIBCQueries. As you might imagine, they all successfully execute Insert,
Post, Open, and Close commands more times than I can count.
1. Your insert is failing, but you haven’t provided us with the SQL you
are using for an insert. Also, check the refresh SQL property of your DB
component.
2. I notice you have an ; at the end of all your SQL. I don’t think that
is necessary when entering the SQL into the SQL
22 matches
Mail list logo