(2 votes, average: 5.00 out of 5)

(2 votes, average: 5.00 out of 5)

Tips : create/alter/drop user in firebird 2.5 , or howto get rid of gsec

On .net provider list Rick Roen is writing a utility to change user password , the best way to change it is from sql :).
Read the user create/delete/update notes.
Now a regular user can change it’s own password without the need for sysdba intervention:

The new DDL command ALTER USER enables an “ordinary” user (a regular Firebird user, a non-root user on POSIX or a trusted user on a Windows system where trusted authentication is enabled) the ability to change his or her password and/or personal name elements, while logged in to any database.

(2 votes, average: 5.00 out of 5)

(1 votes, average: 5.00 out of 5)

Database trends survey (Embarcadero)

Marco Cantu posted in his blog:

…While most of the questions are on the choice and number of servers used (MS SQL Server being the most widely adopted, Oracle the most critical, and Firebird has a significant 4% 5.5% presence for large companies). Other questions are tuned for Embarcadero products (like evaluating the need for automating some DBA tasks). A few questions are interesting for their broad perspective, like those focused on the relationship between developers and DBAs…

Btw, interesting that there is no mention of Embarcadero’s Interbase in the survey results.

(1 votes, average: 5.00 out of 5)

(3 votes, average: 5.00 out of 5)

Learning from bugs using together : list,distinct,case,extract weekday

Seems that the bug CORE-3302 is triggered when there are millions of rows and only in firebird 2.5 and 3.0 (Bug is already fixed in svn)
What you can learn from the bug is the usage of list,distinct,case,extract weekday in the same query

First i have created the query to extract the day in string format from current date
select
list(case extract(weekday from CURRENT_DATE) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from RDB$DATABASE

In my case the result was Fri.
Then you can create a table with different dates:

CREATE table tasks
(
DATE_OF_TASK DATE
);

Populate the table

INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');

Then start to run the query

select
list(distinct case extract(weekday from date_of_task) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from tasks

Result should be:

Fri,Sat,Thu
(No Ratings Yet)

(1 votes, average: 5.00 out of 5)

(1 votes, average: 5.00 out of 5)

Testing boolean columns in Firebird 3.0

After the new year eve i wanted to test the new boolean columns in the new build that added them for firebird 3.0 , so i have created the columns and then inserted some random bool vaules for test after that i have started to test the bool expressions (and , or  …) in a select from the new bool values.

ps: the select worked in isql-fb only , in flamerobin the datatype is not implemented yet (default from ubuntu 0.9.2)

(5 votes, average: 5.00 out of 5)

1 … 230 231 232 233 234 … 495