Hello Alan,
Im using now the extract function an there is 0 = Sunday, 1 = Monday I think.
It’s Friday here today:
select f_dayofweek(current_timestamp) from rdb$database
returns 6
On 8/29/19 4:45 AM, m.djo...@gmail.com [firebird-support] wrote:
>
> In binary representation of the values maybe 4.72 is the closest, but
> we are talking about mathematic.
> This is from the description of the ROUND function in the documentation:
> Rounds a number to the nearest integer. If
Hello Kjell,
then I have to do the mapping between Monday = 1, Tuesday = 2, Sunday = 0. But
I can only select the value with an execute statement.
I will test it, thank you.
WHEN F_DAYOFWEEK(J.COMMDATE)=1 /* Sunday */
??
Alan McDonald
>> DummyPacketInterval = 0 (but this should be irrelevant for this type
>> of issue)
>Try to change it. This _is_ relevant for this type of issue.
That did the trick. Thanks, Dimitry!
Regards
Stefan
What did you change it to?
Alan
Posted by:
>> that does not work - Unknown Column error -206
>
> RTFM Language Reference. In SQL queries PSQL variables must be used with
> colon.
Please mind your tone: you could have phrased that a little bit more friendly
and less hostile.
Mark
--
Mark Rotteveel
+2
>>I use Firebird primarily with Delphi and have had no problems with using and
>>displaying dates >>(suitable for my country - UK.)
You can use this in your select statements for php:
f_dayofmonth(CREATEDATE)||'.'||f_month(CREATEDATE)||'.'||f_year(CREATEDATE)
CREATEDATE
format the PHP
.
Better to co-host your own serer somewhere than use Azure. That was my decision.
Alan McDonald
0413 657 427
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, 21 June 2017 8:09 PM
To: firebird-support@yahoogroups.com
Subject
and formatted text so it may not be suitable for your
needs
Alan McDonald
0413 657 427
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, 9 March 2017 9:48 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] ezSQL
don't know if in Firebird 3.0 it will be
possible to enumerate/list the users (for any of the 3 security models).
I cannot speak for FB3 – not done any work there yet
Thanks again,
David
On Tuesday, February 21, 2017 4:19 PM, "'Alan McDonald' a...@meta.com.au
[firebird-support]"
GER";
GRANT RDB$ADMIN TO "0S0WARDK";
GRANT SELECT, INSERT,
UPDATE(FIRST_NAME,GID,GROUP_NAME,LAST_NAME,MIDDLE_NAME,PASSWD,UID), DELETE ON
USERS TO PUBLIC;
/* Privileges of views */
GRANT ALL ON RDB$USERS TO VIEW USERS;
On Tuesday, February 21, 2017 1:32 PM, "'Alan McDon
In a production environment using Firebird v2.5, we need to delegate authority
of USER CRUD operations to more than one person without these admins sharing
the SYSDBA user and password.
These admins have been created as users with ADMIN ROLE, and are logged in
under the RDB$ADMIN ROLE (eg
Hi,
I am facing a DB corruption issue on firebird database. Everytime my
application tries to open connection or perform any DML activities, randomly i
get the following error.
ERR::I/O error during "CreateFile (open)" operation for file "database"
Error while trying to open file;
Hi guys,
Since Zebedee for Java is a beta ver. and not maintain again, are there any
alternative to this program?
Thanks in advance.
Regards,
Anto
Linux or pc?
I am writing a two way server - client Firebird replication with a C# app and I
am facing the following problem. I have a log table with the table name pk of
the record and type of the query executet on it. For example if in the sales
table there has been inserted a line with primery key of 4
Hello Alan,
Thank you for your answer. I will download the FB Replicator try it and see if
it will work for me.
That part with the triggers i've already done. I have after I, U, D triggers
for every table and they insert into my replication log table. The problem is
that I used to put the
on
Is this intended behaviour? Why doesn't it respond from the gsec command
prompt?
Regards
Alan McDonald
The database path I am using in both my app and IB_SQL.exe is simply the
atabase name myapp.FDB.
When fb_inet_server.exe is running as a background process on the machine both
my app and IB_SQL.exe connect to the server and the app runs as I would expect.
Adam
I have tried both fullpath (D:\my_app\myapp.FDB) and just filename (myapp.FDB)
and in both cases cannot connect.
Adam
And you are using cpLocal?
Alan
Engine Code :335544721
Engine Message:
Unable to complete network request to host localhost
Failed to establish connection.
That means you are trying to use the TCP stack.
Alan
I've only just recently installed the latest version of Firebird and developed
a small test application and associated fdb on a Windows 8 desktop. I've copied
the following Firebird files to the same folder as the exe but cannot connect
to an embedded Firebird:
icudt30.dll
icuin30.dll
Try to put gds32.dll in the system32 folder, AFAIK, FreeAdHocUDF depend on
FreeUDFLib which depend on GDS3.dll in the system folder
On Wed, Apr 16, 2014 at 4:58 AM, Thomas Beckmann
thomas.beckm...@assfinet.de wrote:
That's not correct - I distribute embedded with FreeAdHocUDF and
Okey, thanks for clarifying, i'm having the same problem but with
FreeUDFLib, and i see in the FreeAdHocLib, it use the FreeUDFLib core file
to improve it. I thought it migth related.
You do need the intl folder and contents and you do need ib_util
Alan
Hi,
It's missed BLOBs, good that you have this, not critical errors.
Perform backup and restore.
Regards,
Alexey Kovyazin
www.ibsurgeon.com
What's a 'missed' BLOB?
Alan
Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB
Hello Group,
Is it possible to take a backup of a 2.5 database whilst it is running in
embedded mode (Windows) and whilst that application is otherwise connected to
the database using the services manager (just like you can on the full server)?
I am presently getting an exception that the
Cast the result of the extract as a date or timestamp.
On 12/02/2014 6:20 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
On 11-2-2014 16:06, Virna Constantin wrote:
EXTRACT()
http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html
Extract is not the same as PostgreSQL
Alan McDonald
Alan McDonald
Something was being cached - it needed a server restart. Disconnecting and
re-connecting to the database did not clear the cache. Doesn't seem right to
me
Even isql returned the same error message.
Alan
Now I know the values in the field in question are unique - I have only 3
records.
But when I delete all the records from the table, I still get the above
message.
SL Are there other active connections? Have they committed all
transactions?
SL FB Indexes contain information for **all
In general, moving Firebird database files is a definite no-no. You copy
or
move Firebird databases by gbak'ing them and restoring them at the new
location.
What? Is there more to knowing that if you stop the fbserver, it's safe to
copy an .fdb file than there is to know how to manipulate
being written to somewhere that I can't find?
(WIN32) V2.5
Regards
Alan McDonald
Hi Alan,
I notice that it is now possible to connect to a database via the
embedded server and simultaneously connect via other embedded
processes to the same database file. This was not possible in previous
version - the second process would be locked out.
Can someone lead me to an
Hello, Paul, Alan!
PV Windows Embedded now contains a SuperClassic instead of a
SuperServer engine.
PV File locks are shared, so a database can be accessed by one or more
PV Embedded servers and a regular Classic or SuperClassic server at the
same time.
PV Consult the Firebird 2.5
04.01.2014 11:51, Alan McDonald wrote:
Users with RDB$ADMIN granted to them have the ability to creates users.
They can, of course, also grant other roles to users.
But they cannot revoke roles already granted to a user by another
RDB$ADMIN or SYSDBA since the RDB$GRANTOR is always
to allow all RDB$ADMIN role users, the permissions to
allow granting and revoking of roles granted by other users?
Regards
Alan McDonald
I seem to remember some time ago someone worked out that it was possible to
run embedded firebird on apache (i.e. on a shared unix environment). Does
anyone know if this is possible and how?
Regards
Alan McDonald
Now it's a task to find the user who actually granted the role
SYSDBA does not overwrite this either. SYSDBA logged as any role
including RD B$ADMIN does not give me the ability to revoke the role.
It must be the user (not just the RDB$ADMIN role) who granted the role.
It may be
Vlad,
Sorry if you (and someone else) have to google what File-Based Write Filter
means.
Firebird runs in WES and WES7 like in any Windows computer.
I have use it several years.
(WES, Windows Embedded Standard is XP and WES7 is Windows 7).
Now I have situation that I must use FBWF.
When I have
://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
--
regards
Alan McDonald
Check the page size of the restored vs previous db
Alan
On 24/07/2013 8:19 PM, SysAdm sys...@swic.eu wrote:
Hello,
I have this strange problem on gbak. Usually every night I was doing a
full backup of a database and a subsequent restore order to remove the
garbage and optimize the database.
Not fool proof at all really. DB needs to be off line from the second the
backup starts until the restored file is renamed.
You need a better way
Alan
On 01/06/2013 4:22 PM, sir_wally_lewis rgilland1...@gmail.com wrote:
current practice is.
- backup database
- restore to new name.
- rename
2.5.2 - this is not the case. I get an exception
unsuccessful metadata update SYSDBA is not grantor of Role on MANAGER to
0S0ASDFASDF.
Surely this is not intended?
Regards
Alan McDonald
[Non-text portions of this message have been removed]
Hi Alan,
I know in the past that the grantor must be the one who revokes that
role.
But now we have RDB$ADMIN a user with role RDB$ADMIN can create,
edit
and delete users and grant a role to another user.
I would have thought SYSDBA or indeed any other RDB$ADMIN user could
revoke
On Tue, Jan 22, 2013 at 4:18 AM, Nicolas Timmers - TCS Sistemas
nico...@tcssistemas.com.br wrote:
Hello Everyone !
Until the new functionalyty of firebird doesn't came out, that is possible
to have per database user's
What's my alternatives ?
I am having real problem of users from a
You are right, I am not sure how it was working but it should have been
SELECT COUNT(*) FROM SURFACE
SELECT FIRST n FROM only reads the first n records I want to read the
last
n records to the end of the DB
FYI, I am a newbie to SQL so I don't know the command syntax very well.
What
I
http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
--
regards
Alan McDonald
If 526 commits then 535 can retry.
Alan
On 07/01/2013 11:34 AM, W O sistemas2000profesio...@gmail.com wrote:
Hello everybody
- Transaction 510 inserts a new row
- Transaction 510 commit
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535
But 535 will need to re acquire the row before it can update.
Alan
On 07/01/2013 11:34 AM, W O sistemas2000profesio...@gmail.com wrote:
Hello everybody
- Transaction 510 inserts a new row
- Transaction 510 commit
- Transaction 526 start
- Transaction 526 updates the row inserted by
:
So, 535 should read again the row, getting now the updated version from
526?
Greetings.
Walter.
On Sun, Jan 6, 2013 at 8:44 PM, Alan McDonald a...@meta.com.au wrote:
**
But 535 will need to re acquire the row before it can update.
Alan
On 07/01/2013 11:34 AM, W O
Your query needs an aggregate field. Count.
Alan
On Oct 24, 2012 1:49 PM, sir_wally_lewis rgilland1...@gmail.com wrote:
Hi,
We use Firebird 2.5.1 on Linux 64 bit
Firebird fails to restore because of a unique constraint( see below ).
However when interrogating the data, no duplicate is
Yep, that looks exactly like my case. Unfortunately, I'm not able to re-create
users by hand because of the scale of the problem (and because I don't
know their passwords, and resetting them means me looking for another job
;) ).
You can pump the data to another database shell without
,
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo! Groups Links
--
regards
Alan McDonald
Search and replace all the reserved words in your application with a non
reserved alternative. Then change all the reserved filenames in yr DB
Alan
Alan McDonald
On 12/03/2012 7:11 PM, talshapira talshap...@yahoo.com wrote:
Hi all,
I'm new to firebird.
I have a legacy application
Links
--
regards
Alan McDonald
[Non-text portions of this message have been removed]
Thanks for all people kindly answering my questions.
Regarding storing blobs in a separate table, Aage = could be better
because
that way a page can hold more records Milan = no need to split blobs into
separate table because FB engine is internally doing this job.
Both seem to make sense
54 matches
Mail list logo